# importing libraries
from __future__ import print_function
from ipywidgets import interact, interactive, fixed, interact_manual
from IPython.core.display import display, HTML
import numpy as np
import pandas as pd
import matplotlib.pyplot as plt
import plotly.express as px
import folium
import plotly.graph_objects as go
import seaborn as sns
import ipywidgets as widgets
# loading data right from the source:
death_df = pd.read_csv('https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_deaths_global.csv')
confirmed_df = pd.read_csv('https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_confirmed_global.csv')
recovered_df = pd.read_csv('https://raw.githubusercontent.com/CSSEGISandData/COVID-19/master/csse_covid_19_data/csse_covid_19_time_series/time_series_covid19_recovered_global.csv')
country_df = pd.read_csv('https://raw.githubusercontent.com/CSSEGISandData/COVID-19/web-data/data/cases_country.csv')
pd.set_option('display.max_rows', None)
pd.set_option('display.max_columns', None)
pd.set_option('display.width', None)
confirmeddf=confirmed_df[confirmed_df.columns[1:2]]
confirmeddf=pd.concat([confirmeddf,confirmed_df[confirmed_df.columns[-7:]]],axis=1)
confirmeddf.head(313)
| Country/Region | 12/18/20 | 12/19/20 | 12/20/20 | 12/21/20 | 12/22/20 | 12/23/20 | 12/24/20 | |
|---|---|---|---|---|---|---|---|---|
| 0 | Afghanistan | 49621 | 49681 | 49817 | 50013 | 50190 | 50433 | 50655 |
| 1 | Albania | 52004 | 52542 | 53003 | 53425 | 53814 | 54317 | 54827 |
| 2 | Algeria | 94371 | 94781 | 95203 | 95659 | 96069 | 96549 | 97007 |
| 3 | Andorra | 7519 | 7560 | 7577 | 7602 | 7633 | 7669 | 7699 |
| 4 | Angola | 16562 | 16626 | 16644 | 16686 | 16802 | 16931 | 17029 |
| 5 | Antigua and Barbuda | 152 | 152 | 153 | 153 | 153 | 154 | 154 |
| 6 | Argentina | 1531374 | 1537169 | 1541285 | 1547138 | 1555279 | 1563865 | 1563865 |
| 7 | Armenia | 152253 | 153173 | 153825 | 154065 | 154602 | 155440 | 156142 |
| 8 | Australia | 117 | 117 | 118 | 118 | 118 | 118 | 118 |
| 9 | Australia | 4712 | 4748 | 4771 | 4789 | 4805 | 4823 | 4832 |
| 10 | Australia | 69 | 71 | 71 | 71 | 71 | 73 | 73 |
| 11 | Australia | 1232 | 1234 | 1235 | 1235 | 1236 | 1238 | 1240 |
| 12 | Australia | 563 | 563 | 566 | 566 | 566 | 568 | 568 |
| 13 | Australia | 234 | 234 | 234 | 234 | 234 | 234 | 234 |
| 14 | Australia | 20354 | 20356 | 20357 | 20360 | 20361 | 20361 | 20361 |
| 15 | Australia | 845 | 845 | 846 | 846 | 846 | 847 | 848 |
| 16 | Austria | 334913 | 337209 | 338854 | 340373 | 342226 | 344357 | 347204 |
| 17 | Azerbaijan | 195422 | 199127 | 202088 | 203593 | 205877 | 208211 | 210061 |
| 18 | Bahamas | 7733 | 7733 | 7746 | 7765 | 7772 | 7788 | 7788 |
| 19 | Bahrain | 89883 | 90062 | 90282 | 90450 | 90634 | 90817 | 91070 |
| 20 | Bangladesh | 498293 | 499560 | 500713 | 502183 | 503501 | 504868 | 506102 |
| 21 | Barbados | 307 | 307 | 307 | 321 | 327 | 329 | 345 |
| 22 | Belarus | 169648 | 171579 | 173523 | 175416 | 177274 | 179196 | 181113 |
| 23 | Belgium | 621039 | 623760 | 625930 | 626911 | 629109 | 632321 | 634904 |
| 24 | Belize | 9791 | 9791 | 9791 | 10145 | 10257 | 10370 | 10490 |
| 25 | Benin | 3152 | 3152 | 3167 | 3167 | 3167 | 3205 | 3205 |
| 26 | Bhutan | 443 | 443 | 446 | 479 | 479 | 519 | 519 |
| 27 | Bolivia | 149149 | 149770 | 150023 | 150385 | 151059 | 152064 | 153121 |
| 28 | Bosnia and Herzegovina | 104881 | 105524 | 105524 | 106222 | 106986 | 107570 | 108298 |
| 29 | Botswana | 13014 | 13014 | 13014 | 13622 | 13622 | 13622 | 14025 |
| 30 | Brazil | 7162978 | 7213155 | 7238600 | 7263619 | 7318821 | 7365517 | 7423945 |
| 31 | Brunei | 152 | 152 | 152 | 152 | 152 | 152 | 152 |
| 32 | Bulgaria | 190027 | 191029 | 191195 | 192472 | 194271 | 195886 | 196658 |
| 33 | Burkina Faso | 4832 | 4954 | 5160 | 5301 | 5461 | 5649 | 5941 |
| 34 | Burma | 114198 | 115187 | 116134 | 116982 | 117946 | 118869 | 119788 |
| 35 | Burundi | 751 | 761 | 761 | 762 | 762 | 773 | 773 |
| 36 | Cabo Verde | 11526 | 11567 | 11579 | 11600 | 11636 | 11668 | 11688 |
| 37 | Cambodia | 362 | 362 | 363 | 363 | 363 | 363 | 363 |
| 38 | Cameroon | 25472 | 25724 | 25849 | 25849 | 25849 | 25849 | 26277 |
| 39 | Canada | 87581 | 88933 | 90219 | 91459 | 92480 | 93781 | 93781 |
| 40 | Canada | 45400 | 45400 | 45400 | 47067 | 47510 | 48027 | 48609 |
| 41 | Canada | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 42 | Canada | 13 | 13 | 13 | 13 | 13 | 13 | 13 |
| 43 | Canada | 22397 | 22630 | 22859 | 23025 | 23180 | 23381 | 23624 |
| 44 | Canada | 573 | 578 | 574 | 578 | 580 | 585 | 587 |
| 45 | Canada | 372 | 380 | 382 | 382 | 383 | 384 | 384 |
| 46 | Canada | 24 | 24 | 24 | 24 | 24 | 24 | 24 |
| 47 | Canada | 1443 | 1445 | 1445 | 1447 | 1454 | 1458 | 1465 |
| 48 | Canada | 259 | 259 | 259 | 262 | 262 | 264 | 265 |
| 49 | Canada | 155180 | 157749 | 159871 | 162052 | 164318 | 166802 | 169137 |
| 50 | Canada | 90 | 90 | 90 | 90 | 91 | 91 | 94 |
| 51 | Canada | 172801 | 174839 | 176985 | 179093 | 181276 | 183523 | 185872 |
| 52 | Canada | 13 | 13 | 13 | 13 | 13 | 13 | 13 |
| 53 | Canada | 13077 | 13329 | 13555 | 13761 | 13942 | 14101 | 14255 |
| 54 | Canada | 59 | 59 | 59 | 59 | 59 | 59 | 60 |
| 55 | Central African Republic | 4936 | 4936 | 4936 | 4936 | 4936 | 4948 | 4948 |
| 56 | Chad | 1839 | 1867 | 1890 | 1902 | 1916 | 1938 | 1958 |
| 57 | Chile | 581135 | 583355 | 585546 | 587993 | 589189 | 590914 | 594152 |
| 58 | China | 992 | 992 | 992 | 992 | 992 | 992 | 992 |
| 59 | China | 959 | 961 | 961 | 961 | 961 | 961 | 961 |
| 60 | China | 590 | 590 | 590 | 590 | 590 | 590 | 590 |
| 61 | China | 504 | 505 | 507 | 507 | 507 | 507 | 507 |
| 62 | China | 182 | 182 | 182 | 182 | 182 | 182 | 182 |
| 63 | China | 2027 | 2028 | 2031 | 2034 | 2035 | 2036 | 2037 |
| 64 | China | 264 | 264 | 264 | 264 | 264 | 264 | 264 |
| 65 | China | 147 | 147 | 147 | 147 | 147 | 147 | 147 |
| 66 | China | 171 | 171 | 171 | 171 | 171 | 171 | 171 |
| 67 | China | 373 | 373 | 373 | 373 | 373 | 373 | 373 |
| 68 | China | 960 | 960 | 961 | 961 | 961 | 961 | 961 |
| 69 | China | 1296 | 1297 | 1297 | 1297 | 1297 | 1298 | 1298 |
| 70 | China | 7969 | 8078 | 8152 | 8237 | 8300 | 8353 | 8424 |
| 71 | China | 68149 | 68149 | 68149 | 68149 | 68149 | 68149 | 68149 |
| 72 | China | 1020 | 1020 | 1020 | 1020 | 1020 | 1020 | 1020 |
| 73 | China | 342 | 344 | 350 | 352 | 352 | 352 | 352 |
| 74 | China | 684 | 684 | 684 | 684 | 684 | 684 | 684 |
| 75 | China | 935 | 935 | 935 | 935 | 935 | 935 | 935 |
| 76 | China | 157 | 157 | 157 | 157 | 157 | 157 | 157 |
| 77 | China | 290 | 291 | 292 | 294 | 295 | 302 | 310 |
| 78 | China | 46 | 46 | 46 | 46 | 46 | 46 | 46 |
| 79 | China | 75 | 75 | 75 | 75 | 75 | 75 | 75 |
| 80 | China | 18 | 18 | 18 | 18 | 18 | 18 | 18 |
| 81 | China | 502 | 504 | 504 | 504 | 504 | 504 | 504 |
| 82 | China | 861 | 861 | 861 | 861 | 861 | 861 | 861 |
| 83 | China | 1436 | 1447 | 1455 | 1461 | 1473 | 1479 | 1483 |
| 84 | China | 223 | 223 | 224 | 224 | 224 | 224 | 224 |
| 85 | China | 839 | 840 | 841 | 843 | 843 | 845 | 846 |
| 86 | China | 304 | 304 | 304 | 304 | 304 | 304 | 304 |
| 87 | China | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| 88 | China | 980 | 980 | 980 | 980 | 980 | 980 | 980 |
| 89 | China | 227 | 227 | 227 | 227 | 227 | 227 | 227 |
| 90 | China | 1298 | 1299 | 1299 | 1299 | 1300 | 1300 | 1300 |
| 91 | Colombia | 1482072 | 1496062 | 1507222 | 1518067 | 1530593 | 1544826 | 1559766 |
| 92 | Comoros | 643 | 643 | 666 | 666 | 693 | 693 | 715 |
| 93 | Congo (Brazzaville) | 6200 | 6200 | 6200 | 6200 | 6571 | 6571 | 6571 |
| 94 | Congo (Kinshasa) | 15089 | 15397 | 15495 | 15669 | 15810 | 16039 | 16282 |
| 95 | Costa Rica | 157472 | 157472 | 157472 | 159893 | 160804 | 161942 | 162990 |
| 96 | Cote d'Ivoire | 21845 | 21890 | 21918 | 21932 | 21942 | 21984 | 22071 |
| 97 | Croatia | 190235 | 192987 | 194962 | 195728 | 197323 | 200086 | 202319 |
| 98 | Cuba | 9893 | 10024 | 10127 | 10242 | 10384 | 10500 | 10717 |
| 99 | Cyprus | 16647 | 17476 | 17688 | 18004 | 18004 | 18883 | 19316 |
| 100 | Czechia | 610006 | 618836 | 624140 | 627523 | 635414 | 646312 | 660461 |
| 101 | Denmark | 534 | 539 | 546 | 547 | 550 | 556 | 561 |
| 102 | Denmark | 19 | 19 | 19 | 25 | 25 | 25 | 25 |
| 103 | Denmark | 128321 | 131606 | 134434 | 137632 | 140175 | 143472 | 146341 |
| 104 | Diamond Princess | 712 | 712 | 712 | 712 | 712 | 712 | 712 |
| 105 | Djibouti | 5780 | 5781 | 5781 | 5783 | 5786 | 5789 | 5800 |
| 106 | Dominica | 88 | 88 | 88 | 88 | 88 | 88 | 88 |
| 107 | Dominican Republic | 157929 | 159064 | 160386 | 161052 | 161930 | 162496 | 163654 |
| 108 | Ecuador | 205003 | 205920 | 206257 | 206329 | 206364 | 207084 | 208010 |
| 109 | Egypt | 124280 | 124891 | 125555 | 126273 | 127061 | 127972 | 128993 |
| 110 | El Salvador | 42397 | 43195 | 43477 | 43772 | 43772 | 43772 | 44619 |
| 111 | Equatorial Guinea | 5214 | 5214 | 5214 | 5231 | 5231 | 5236 | 5236 |
| 112 | Eritrea | 741 | 754 | 754 | 807 | 832 | 877 | 951 |
| 113 | Estonia | 20658 | 21219 | 21794 | 22083 | 22647 | 23309 | 24009 |
| 114 | Eswatini | 7202 | 7305 | 7427 | 7562 | 7715 | 7868 | 8032 |
| 115 | Ethiopia | 119025 | 119494 | 119951 | 120348 | 120638 | 120989 | 121399 |
| 116 | Fiji | 46 | 46 | 46 | 46 | 46 | 46 | 46 |
| 117 | Finland | 32582 | 32853 | 33162 | 33414 | 33717 | 34084 | 34447 |
| 118 | France | 12163 | 12281 | 12369 | 12369 | 12433 | 12499 | 12547 |
| 119 | France | 16182 | 16182 | 16182 | 16345 | 16410 | 16466 | 16550 |
| 120 | France | 8498 | 8498 | 8557 | 8557 | 8557 | 8557 | 8557 |
| 121 | France | 5601 | 5601 | 5634 | 5634 | 5634 | 5634 | 5634 |
| 122 | France | 5616 | 5708 | 5708 | 5708 | 5708 | 5767 | 5767 |
| 123 | France | 37 | 37 | 37 | 37 | 38 | 38 | 38 |
| 124 | France | 8588 | 8704 | 8704 | 8704 | 8801 | 8801 | 8846 |
| 125 | France | 175 | 175 | 175 | 175 | 175 | 184 | 184 |
| 126 | France | 14 | 14 | 14 | 14 | 14 | 15 | 15 |
| 127 | France | 918 | 918 | 918 | 918 | 918 | 961 | 961 |
| 128 | France | 2441737 | 2458839 | 2471458 | 2477255 | 2488889 | 2503693 | 2525234 |
| 129 | Gabon | 9400 | 9400 | 9400 | 9420 | 9420 | 9469 | 9469 |
| 130 | Gambia | 3786 | 3786 | 3786 | 3786 | 3791 | 3791 | 3791 |
| 131 | Georgia | 204003 | 206907 | 208638 | 209462 | 212526 | 214871 | 216843 |
| 132 | Germany | 1486839 | 1508518 | 1514962 | 1534218 | 1570371 | 1604129 | 1630596 |
| 133 | Ghana | 53653 | 53653 | 53653 | 53954 | 53954 | 54043 | 54043 |
| 134 | Greece | 129584 | 130485 | 131072 | 131597 | 132430 | 133365 | 134235 |
| 135 | Grenada | 94 | 94 | 103 | 103 | 103 | 105 | 105 |
| 136 | Guatemala | 132062 | 132595 | 132765 | 132867 | 133601 | 134256 | 134894 |
| 137 | Guinea | 13511 | 13532 | 13545 | 13578 | 13578 | 13598 | 13630 |
| 138 | Guinea-Bissau | 2447 | 2447 | 2447 | 2447 | 2447 | 2447 | 2447 |
| 139 | Guyana | 6076 | 6105 | 6125 | 6171 | 6216 | 6258 | 6266 |
| 140 | Haiti | 9648 | 9674 | 9674 | 9763 | 9771 | 9805 | 9805 |
| 141 | Holy See | 27 | 27 | 27 | 27 | 27 | 27 | 27 |
| 142 | Honduras | 116212 | 116212 | 117022 | 117190 | 117588 | 118036 | 118036 |
| 143 | Hungary | 295977 | 300022 | 302989 | 305130 | 306368 | 308262 | 311554 |
| 144 | Iceland | 5604 | 5621 | 5642 | 5656 | 5667 | 5683 | 5683 |
| 145 | India | 10004599 | 10031223 | 10055560 | 10075116 | 10099066 | 10123778 | 10146845 |
| 146 | Indonesia | 650197 | 657948 | 664930 | 671778 | 678125 | 685639 | 692838 |
| 147 | Iran | 1145651 | 1152072 | 1158384 | 1164535 | 1170743 | 1177004 | 1183182 |
| 148 | Iraq | 581811 | 583118 | 584145 | 585345 | 586503 | 587676 | 588803 |
| 149 | Ireland | 78254 | 78776 | 79542 | 80267 | 81228 | 82155 | 83073 |
| 150 | Israel | 370152 | 372886 | 374760 | 378259 | 382487 | 385022 | 389678 |
| 151 | Italy | 1921778 | 1938083 | 1953185 | 1964054 | 1977370 | 1991278 | 2009317 |
| 152 | Jamaica | 12039 | 12135 | 12224 | 12289 | 12354 | 12423 | 12519 |
| 153 | Japan | 193753 | 196815 | 199270 | 201074 | 203732 | 207007 | 210769 |
| 154 | Jordan | 271514 | 272797 | 274949 | 277448 | 279892 | 281983 | 283690 |
| 155 | Kazakhstan | 190292 | 190969 | 191650 | 192579 | 193503 | 194257 | 194993 |
| 156 | Kenya | 93761 | 94151 | 94500 | 94614 | 94768 | 95195 | 95431 |
| 157 | Korea, South | 48570 | 49665 | 50591 | 51460 | 52550 | 53533 | 54770 |
| 158 | Kosovo | 48337 | 48682 | 48905 | 49169 | 49169 | 49440 | 49440 |
| 159 | Kuwait | 147531 | 147775 | 147979 | 148209 | 148507 | 148773 | 149017 |
| 160 | Kyrgyzstan | 78679 | 78911 | 79254 | 79254 | 79429 | 79659 | 79845 |
| 161 | Laos | 41 | 41 | 41 | 41 | 41 | 41 | 41 |
| 162 | Latvia | 29427 | 30297 | 30940 | 31335 | 32339 | 33484 | 34754 |
| 163 | Lebanon | 154944 | 156570 | 158104 | 159286 | 160979 | 163225 | 165933 |
| 164 | Lesotho | 2546 | 2546 | 2546 | 2546 | 2546 | 2725 | 2725 |
| 165 | Liberia | 1779 | 1779 | 1779 | 1779 | 1779 | 1779 | 1779 |
| 166 | Libya | 93772 | 93772 | 94560 | 95200 | 95706 | 96346 | 97192 |
| 167 | Liechtenstein | 1676 | 1711 | 1758 | 1784 | 1826 | 1858 | 1920 |
| 168 | Lithuania | 106210 | 109429 | 112359 | 114487 | 116358 | 120094 | 123889 |
| 169 | Luxembourg | 43728 | 43728 | 43728 | 44582 | 44809 | 45209 | 45209 |
| 170 | MS Zaandam | 9 | 9 | 9 | 9 | 9 | 9 | 9 |
| 171 | Madagascar | 17587 | 17587 | 17633 | 17633 | 17633 | 17633 | 17633 |
| 172 | Malawi | 6148 | 6153 | 6161 | 6202 | 6248 | 6261 | 6277 |
| 173 | Malaysia | 90816 | 91969 | 93309 | 95327 | 97389 | 98737 | 100318 |
| 174 | Maldives | 13444 | 13474 | 13493 | 13501 | 13524 | 13537 | 13558 |
| 175 | Mali | 6120 | 6164 | 6191 | 6232 | 6291 | 6347 | 6441 |
| 176 | Malta | 11569 | 11621 | 11714 | 11802 | 11910 | 11992 | 12062 |
| 177 | Marshall Islands | 4 | 4 | 4 | 4 | 4 | 4 | 4 |
| 178 | Mauritania | 12046 | 12278 | 12418 | 12567 | 12745 | 12944 | 13118 |
| 179 | Mauritius | 524 | 524 | 524 | 524 | 526 | 527 | 527 |
| 180 | Mexico | 1301546 | 1313675 | 1320545 | 1325915 | 1338426 | 1350079 | 1362564 |
| 181 | Moldova | 133360 | 134578 | 135207 | 135910 | 136931 | 138213 | 139435 |
| 182 | Monaco | 715 | 723 | 728 | 742 | 756 | 767 | 783 |
| 183 | Mongolia | 953 | 961 | 993 | 1006 | 1063 | 1069 | 1075 |
| 184 | Montenegro | 43390 | 43709 | 43955 | 44284 | 44542 | 45062 | 45423 |
| 185 | Morocco | 412393 | 415226 | 417125 | 418002 | 420648 | 423214 | 425864 |
| 186 | Mozambique | 17338 | 17477 | 17568 | 17695 | 17767 | 17767 | 18031 |
| 187 | Namibia | 18041 | 18437 | 18714 | 19299 | 19629 | 19984 | 20579 |
| 188 | Nepal | 252474 | 253184 | 253772 | 254514 | 255236 | 255979 | 256592 |
| 189 | Netherlands | 5138 | 5155 | 5163 | 5176 | 5199 | 5228 | 5257 |
| 190 | Netherlands | 177 | 179 | 179 | 179 | 179 | 182 | 182 |
| 191 | Netherlands | 3881 | 3920 | 3947 | 3974 | 4006 | 4051 | 4099 |
| 192 | Netherlands | 1315 | 1323 | 1328 | 1338 | 1362 | 1370 | 1385 |
| 193 | Netherlands | 664456 | 676673 | 689705 | 700873 | 710683 | 721071 | 732570 |
| 194 | New Zealand | 2110 | 2116 | 2121 | 2121 | 2128 | 2128 | 2128 |
| 195 | Nicaragua | 5938 | 5938 | 5938 | 5938 | 5938 | 5991 | 5991 |
| 196 | Niger | 2560 | 2612 | 2659 | 2724 | 2803 | 2876 | 2933 |
| 197 | Nigeria | 77013 | 77933 | 78434 | 78790 | 79789 | 80922 | 81963 |
| 198 | North Macedonia | 77134 | 77949 | 78305 | 78434 | 79190 | 79815 | 80407 |
| 199 | Norway | 43207 | 43582 | 43905 | 44336 | 44932 | 45455 | 45931 |
| 200 | Oman | 127019 | 127019 | 127667 | 127931 | 128143 | 128236 | 128290 |
| 201 | Pakistan | 454673 | 457288 | 458968 | 460672 | 462814 | 465070 | 467222 |
| 202 | Panama | 206310 | 209584 | 212339 | 214038 | 217202 | 220261 | 223674 |
| 203 | Papua New Guinea | 760 | 760 | 760 | 761 | 761 | 761 | 780 |
| 204 | Paraguay | 98296 | 99157 | 99789 | 100612 | 101544 | 102371 | 103329 |
| 205 | Peru | 989457 | 989457 | 995899 | 997517 | 998475 | 1000153 | 1000153 |
| 206 | Philippines | 456562 | 458044 | 459789 | 461505 | 462815 | 464004 | 465724 |
| 207 | Poland | 1182864 | 1194110 | 1202700 | 1207333 | 1214525 | 1226883 | 1239998 |
| 208 | Portugal | 366952 | 370787 | 374121 | 376220 | 378656 | 383258 | 387636 |
| 209 | Qatar | 141716 | 141858 | 142001 | 142159 | 142308 | 142448 | 142605 |
| 210 | Romania | 582786 | 587944 | 591294 | 593783 | 598792 | 604251 | 608561 |
| 211 | Russia | 2764843 | 2792615 | 2821125 | 2850042 | 2878382 | 2905196 | 2934695 |
| 212 | Rwanda | 7105 | 7232 | 7293 | 7402 | 7511 | 7598 | 7670 |
| 213 | Saint Kitts and Nevis | 30 | 30 | 30 | 30 | 30 | 30 | 30 |
| 214 | Saint Lucia | 280 | 282 | 287 | 287 | 303 | 305 | 305 |
| 215 | Saint Vincent and the Grenadines | 100 | 100 | 104 | 104 | 107 | 108 | 108 |
| 216 | Samoa | 2 | 2 | 2 | 2 | 2 | 2 | 2 |
| 217 | San Marino | 2072 | 2107 | 2107 | 2135 | 2176 | 2205 | 2231 |
| 218 | Sao Tome and Principe | 1011 | 1012 | 1012 | 1012 | 1012 | 1012 | 1012 |
| 219 | Saudi Arabia | 360690 | 360848 | 361010 | 361178 | 361359 | 361536 | 361725 |
| 220 | Senegal | 17559 | 17670 | 17758 | 17879 | 17945 | 18043 | 18200 |
| 221 | Serbia | 292640 | 296528 | 300062 | 303747 | 307827 | 312253 | 316344 |
| 222 | Seychelles | 202 | 202 | 202 | 205 | 205 | 205 | 205 |
| 223 | Sierra Leone | 2486 | 2497 | 2509 | 2509 | 2518 | 2524 | 2531 |
| 224 | Singapore | 58386 | 58403 | 58422 | 58432 | 58461 | 58482 | 58495 |
| 225 | Slovakia | 146124 | 149275 | 151336 | 152555 | 155218 | 158905 | 161562 |
| 226 | Slovenia | 103555 | 105013 | 105899 | 106294 | 107805 | 109934 | 112021 |
| 227 | Solomon Islands | 17 | 17 | 17 | 17 | 17 | 17 | 17 |
| 228 | Somalia | 4662 | 4662 | 4662 | 4662 | 4690 | 4690 | 4690 |
| 229 | South Africa | 901538 | 912477 | 921922 | 930711 | 940212 | 954258 | 968563 |
| 230 | South Sudan | 3228 | 3228 | 3228 | 3234 | 3234 | 3455 | 3455 |
| 231 | Spain | 1797236 | 1797236 | 1797236 | 1819249 | 1829903 | 1842289 | 1854951 |
| 232 | Sri Lanka | 36049 | 36667 | 37261 | 37631 | 38059 | 38639 | 39231 |
| 233 | Sudan | 22265 | 22621 | 22823 | 22963 | 23316 | 23316 | 23316 |
| 234 | Suriname | 5459 | 5511 | 5552 | 5583 | 5669 | 5734 | 5810 |
| 235 | Sweden | 367120 | 367120 | 367120 | 367120 | 389439 | 396048 | 396048 |
| 236 | Switzerland | 403989 | 403989 | 403989 | 413991 | 418266 | 423299 | 428197 |
| 237 | Syria | 9928 | 10050 | 10195 | 10318 | 10442 | 10571 | 10701 |
| 238 | Taiwan* | 759 | 763 | 766 | 766 | 770 | 776 | 776 |
| 239 | Tajikistan | 12888 | 12923 | 12960 | 12998 | 13034 | 13071 | 13106 |
| 240 | Tanzania | 509 | 509 | 509 | 509 | 509 | 509 | 509 |
| 241 | Thailand | 4331 | 4907 | 4907 | 5716 | 5716 | 5762 | 5910 |
| 242 | Timor-Leste | 31 | 31 | 31 | 31 | 31 | 33 | 41 |
| 243 | Togo | 3350 | 3396 | 3416 | 3436 | 3467 | 3494 | 3520 |
| 244 | Trinidad and Tobago | 6955 | 6974 | 7000 | 7012 | 7024 | 7071 | 7089 |
| 245 | Tunisia | 117582 | 119151 | 120687 | 121718 | 123323 | 125000 | 126752 |
| 246 | Turkey | 1982090 | 2004285 | 2024601 | 2043704 | 2062960 | 2082610 | 2100712 |
| 247 | US | 17459296 | 17655591 | 17844690 | 18035209 | 18230242 | 18458373 | 18650454 |
| 248 | Uganda | 30071 | 30702 | 31187 | 31384 | 31910 | 32399 | 32914 |
| 249 | Ukraine | 970758 | 982937 | 991700 | 998678 | 1007627 | 1018199 | 1030125 |
| 250 | United Arab Emirates | 191150 | 192404 | 193575 | 194652 | 195878 | 197124 | 198435 |
| 251 | United Kingdom | 10 | 10 | 10 | 10 | 11 | 11 | 11 |
| 252 | United Kingdom | 497 | 516 | 527 | 527 | 553 | 553 | 560 |
| 253 | United Kingdom | 80 | 86 | 86 | 86 | 86 | 86 | 86 |
| 254 | United Kingdom | 311 | 311 | 311 | 316 | 316 | 317 | 318 |
| 255 | United Kingdom | 2389 | 2526 | 2629 | 2738 | 2776 | 2857 | 2880 |
| 256 | United Kingdom | 23 | 23 | 23 | 23 | 29 | 29 | 29 |
| 257 | United Kingdom | 1184 | 1211 | 1244 | 1282 | 1330 | 1398 | 1476 |
| 258 | United Kingdom | 373 | 373 | 373 | 374 | 374 | 374 | 374 |
| 259 | United Kingdom | 13 | 13 | 13 | 13 | 13 | 13 | 13 |
| 260 | United Kingdom | 781 | 789 | 798 | 798 | 807 | 807 | 810 |
| 261 | United Kingdom | 1977167 | 2004219 | 2040147 | 2073511 | 2110314 | 2149551 | 2188587 |
| 262 | Uruguay | 11950 | 12557 | 13048 | 13477 | 14001 | 14710 | 15457 |
| 263 | Uzbekistan | 75675 | 75806 | 75933 | 76048 | 76180 | 76315 | 76456 |
| 264 | Vanuatu | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| 265 | Venezuela | 109395 | 109781 | 110075 | 110513 | 110828 | 111024 | 111245 |
| 266 | Vietnam | 1410 | 1411 | 1413 | 1414 | 1420 | 1421 | 1432 |
| 267 | West Bank and Gaza | 119612 | 121216 | 122643 | 123945 | 125506 | 127376 | 129080 |
| 268 | Yemen | 2087 | 2087 | 2087 | 2087 | 2087 | 2087 | 2092 |
| 269 | Zambia | 18575 | 18620 | 18716 | 18768 | 18881 | 19122 | 19234 |
| 270 | Zimbabwe | 12047 | 12151 | 12325 | 12422 | 12544 | 12656 | 12786 |
recovereddf=recovered_df[recovered_df.columns[1:2]]
recovereddf=pd.concat([recovereddf,recovered_df[recovered_df.columns[-7:]]],axis=1)
recovereddf.head(313)
| Country/Region | 12/18/20 | 12/19/20 | 12/20/20 | 12/21/20 | 12/22/20 | 12/23/20 | 12/24/20 | |
|---|---|---|---|---|---|---|---|---|
| 0 | Afghanistan | 38540 | 38613 | 39006 | 39508 | 39585 | 39692 | 40359 |
| 1 | Albania | 27426 | 27831 | 28121 | 28752 | 29249 | 29799 | 30276 |
| 2 | Algeria | 62487 | 62869 | 63260 | 63644 | 64020 | 64401 | 64777 |
| 3 | Andorra | 6919 | 6963 | 6997 | 7028 | 7073 | 7106 | 7171 |
| 4 | Angola | 9345 | 9518 | 9592 | 9695 | 9729 | 9729 | 9729 |
| 5 | Antigua and Barbuda | 141 | 141 | 143 | 143 | 144 | 146 | 146 |
| 6 | Argentina | 1356755 | 1362617 | 1368346 | 1374401 | 1379726 | 1384277 | 1384277 |
| 7 | Armenia | 131213 | 131931 | 132532 | 133176 | 134586 | 135638 | 136766 |
| 8 | Australia | 114 | 114 | 114 | 114 | 114 | 114 | 114 |
| 9 | Australia | 3192 | 3192 | 3192 | 3192 | 3192 | 3192 | 3192 |
| 10 | Australia | 59 | 59 | 59 | 62 | 62 | 62 | 62 |
| 11 | Australia | 1214 | 1214 | 1214 | 1215 | 1215 | 1216 | 1216 |
| 12 | Australia | 559 | 559 | 559 | 559 | 559 | 560 | 560 |
| 13 | Australia | 217 | 217 | 221 | 221 | 221 | 221 | 221 |
| 14 | Australia | 19524 | 19524 | 19524 | 19526 | 19527 | 19527 | 19527 |
| 15 | Australia | 821 | 825 | 826 | 827 | 828 | 830 | 832 |
| 16 | Austria | 297424 | 300611 | 303213 | 305658 | 309595 | 312921 | 315952 |
| 17 | Azerbaijan | 131252 | 135462 | 139779 | 142807 | 147199 | 151660 | 155886 |
| 18 | Bahamas | 6109 | 6109 | 6122 | 6127 | 6166 | 6166 | 6166 |
| 19 | Bahrain | 88003 | 88178 | 88331 | 88542 | 88666 | 88826 | 88963 |
| 20 | Bangladesh | 433614 | 435601 | 437527 | 439694 | 441929 | 444345 | 446690 |
| 21 | Barbados | 280 | 280 | 280 | 281 | 284 | 290 | 291 |
| 22 | Belarus | 147316 | 149353 | 151635 | 152930 | 154807 | 157079 | 159437 |
| 23 | Belgium | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 24 | Belize | 4779 | 4779 | 4779 | 8435 | 8802 | 8933 | 9081 |
| 25 | Benin | 2972 | 2972 | 3061 | 3061 | 3061 | 3061 | 3061 |
| 26 | Bhutan | 422 | 423 | 423 | 430 | 430 | 438 | 438 |
| 27 | Bolivia | 127540 | 127815 | 127969 | 128308 | 128540 | 129052 | 129387 |
| 28 | Bosnia and Herzegovina | 70249 | 70620 | 70620 | 71548 | 72597 | 73149 | 73896 |
| 29 | Botswana | 10535 | 10535 | 10535 | 11147 | 11147 | 11147 | 11627 |
| 30 | Brazil | 6322955 | 6388938 | 6408517 | 6469310 | 6501341 | 6512717 | 6512717 |
| 31 | Brunei | 148 | 149 | 149 | 149 | 149 | 149 | 149 |
| 32 | Bulgaria | 96622 | 98026 | 99758 | 102666 | 105090 | 106465 | 107680 |
| 33 | Burkina Faso | 3403 | 3504 | 3659 | 3758 | 3877 | 4018 | 4129 |
| 34 | Burma | 92916 | 94118 | 95387 | 96685 | 97819 | 99325 | 99927 |
| 35 | Burundi | 640 | 687 | 687 | 687 | 687 | 687 | 687 |
| 36 | Cabo Verde | 11164 | 11215 | 11248 | 11270 | 11275 | 11311 | 11366 |
| 37 | Cambodia | 345 | 345 | 345 | 347 | 349 | 349 | 354 |
| 38 | Cameroon | 23851 | 23851 | 23851 | 23851 | 23851 | 23851 | 24892 |
| 39 | Canada | 410988 | 416901 | 422175 | 429372 | 437458 | 444166 | 448119 |
| 40 | Central African Republic | 1924 | 1924 | 1924 | 1924 | 1924 | 1924 | 1924 |
| 41 | Chad | 1630 | 1632 | 1632 | 1633 | 1634 | 1638 | 1651 |
| 42 | Chile | 552289 | 554333 | 555956 | 557913 | 559845 | 561794 | 563457 |
| 43 | China | 986 | 986 | 986 | 986 | 986 | 986 | 986 |
| 44 | China | 940 | 940 | 940 | 940 | 941 | 941 | 941 |
| 45 | China | 584 | 584 | 584 | 584 | 584 | 584 | 584 |
| 46 | China | 477 | 478 | 480 | 482 | 484 | 485 | 486 |
| 47 | China | 180 | 180 | 180 | 180 | 180 | 180 | 180 |
| 48 | China | 1977 | 1979 | 1982 | 1982 | 1986 | 1993 | 1995 |
| 49 | China | 261 | 261 | 261 | 261 | 261 | 261 | 261 |
| 50 | China | 145 | 145 | 145 | 145 | 145 | 145 | 145 |
| 51 | China | 165 | 165 | 165 | 165 | 165 | 165 | 165 |
| 52 | China | 367 | 367 | 367 | 367 | 367 | 367 | 367 |
| 53 | China | 936 | 936 | 936 | 936 | 936 | 937 | 937 |
| 54 | China | 1268 | 1269 | 1269 | 1270 | 1270 | 1270 | 1270 |
| 55 | China | 6628 | 6737 | 6837 | 6910 | 6995 | 7112 | 7203 |
| 56 | China | 63637 | 63637 | 63637 | 63637 | 63637 | 63637 | 63637 |
| 57 | China | 1016 | 1016 | 1016 | 1016 | 1016 | 1016 | 1016 |
| 58 | China | 324 | 326 | 329 | 331 | 331 | 335 | 336 |
| 59 | China | 677 | 678 | 679 | 679 | 679 | 679 | 679 |
| 60 | China | 934 | 934 | 934 | 934 | 934 | 934 | 934 |
| 61 | China | 155 | 155 | 155 | 155 | 155 | 155 | 155 |
| 62 | China | 287 | 287 | 287 | 287 | 287 | 287 | 287 |
| 63 | China | 46 | 46 | 46 | 46 | 46 | 46 | 46 |
| 64 | China | 75 | 75 | 75 | 75 | 75 | 75 | 75 |
| 65 | China | 18 | 18 | 18 | 18 | 18 | 18 | 18 |
| 66 | China | 485 | 485 | 485 | 485 | 485 | 487 | 487 |
| 67 | China | 841 | 841 | 841 | 841 | 841 | 841 | 841 |
| 68 | China | 1336 | 1346 | 1351 | 1352 | 1358 | 1362 | 1367 |
| 69 | China | 220 | 220 | 220 | 220 | 221 | 221 | 221 |
| 70 | China | 798 | 800 | 801 | 801 | 804 | 806 | 807 |
| 71 | China | 296 | 296 | 296 | 297 | 297 | 298 | 298 |
| 72 | China | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| 73 | China | 977 | 977 | 977 | 977 | 977 | 977 | 977 |
| 74 | China | 211 | 211 | 211 | 211 | 211 | 213 | 213 |
| 75 | China | 1290 | 1290 | 1290 | 1290 | 1290 | 1290 | 1290 |
| 76 | Colombia | 1354021 | 1362543 | 1373332 | 1382340 | 1394374 | 1404168 | 1417316 |
| 77 | Comoros | 610 | 610 | 611 | 611 | 615 | 615 | 626 |
| 78 | Congo (Brazzaville) | 4988 | 4988 | 4988 | 4988 | 4988 | 4988 | 4988 |
| 79 | Congo (Kinshasa) | 13010 | 13310 | 13447 | 13660 | 13736 | 13736 | 13982 |
| 80 | Costa Rica | 125488 | 125488 | 125488 | 126777 | 127618 | 128216 | 128842 |
| 81 | Cote d'Ivoire | 21420 | 21451 | 21478 | 21517 | 21536 | 21573 | 21629 |
| 82 | Croatia | 165915 | 169768 | 173158 | 176366 | 178880 | 180735 | 183532 |
| 83 | Cuba | 8912 | 8976 | 9040 | 9126 | 9219 | 9307 | 9378 |
| 84 | Cyprus | 2057 | 2057 | 2057 | 2057 | 2057 | 2057 | 2057 |
| 85 | Czechia | 527062 | 531622 | 533307 | 534686 | 541012 | 546926 | 552444 |
| 86 | Denmark | 516 | 516 | 518 | 518 | 524 | 526 | 526 |
| 87 | Denmark | 18 | 19 | 19 | 19 | 19 | 19 | 19 |
| 88 | Denmark | 87560 | 89570 | 91263 | 93214 | 95933 | 99025 | 102184 |
| 89 | Diamond Princess | 699 | 699 | 699 | 699 | 699 | 699 | 699 |
| 90 | Djibouti | 5641 | 5649 | 5659 | 5668 | 5676 | 5681 | 5690 |
| 91 | Dominica | 83 | 83 | 83 | 83 | 83 | 83 | 83 |
| 92 | Dominican Republic | 122406 | 123284 | 124276 | 124931 | 125715 | 125965 | 126732 |
| 93 | Ecuador | 177951 | 177951 | 177951 | 181618 | 181618 | 181618 | 181618 |
| 94 | Egypt | 106157 | 106481 | 106817 | 107162 | 107563 | 107961 | 108474 |
| 95 | El Salvador | 38481 | 39016 | 39142 | 39362 | 39362 | 39362 | 39989 |
| 96 | Equatorial Guinea | 5064 | 5064 | 5064 | 5077 | 5077 | 5078 | 5078 |
| 97 | Eritrea | 572 | 580 | 580 | 597 | 599 | 599 | 600 |
| 98 | Estonia | 12922 | 13488 | 13590 | 13677 | 14395 | 14898 | 15393 |
| 99 | Eswatini | 6624 | 6662 | 6696 | 6761 | 6821 | 6879 | 6952 |
| 100 | Ethiopia | 100859 | 102153 | 102980 | 103681 | 104818 | 105824 | 106845 |
| 101 | Fiji | 42 | 42 | 42 | 42 | 44 | 44 | 44 |
| 102 | Finland | 22500 | 22500 | 22500 | 22500 | 22500 | 26000 | 26000 |
| 103 | France | 9995 | 9995 | 9995 | 9995 | 9995 | 9995 | 9995 |
| 104 | France | 4842 | 4842 | 4842 | 4842 | 4842 | 4842 | 4842 |
| 105 | France | 2242 | 2242 | 2242 | 2242 | 2242 | 2242 | 2242 |
| 106 | France | 98 | 98 | 98 | 98 | 98 | 98 | 98 |
| 107 | France | 2964 | 2964 | 2964 | 2964 | 2964 | 2964 | 2964 |
| 108 | France | 35 | 35 | 35 | 35 | 37 | 37 | 37 |
| 109 | France | 8219 | 8219 | 8219 | 8219 | 8219 | 8219 | 8219 |
| 110 | France | 161 | 161 | 161 | 161 | 161 | 172 | 172 |
| 111 | France | 14 | 14 | 14 | 14 | 14 | 14 | 14 |
| 112 | France | 780 | 780 | 780 | 780 | 780 | 855 | 855 |
| 113 | France | 159138 | 160053 | 160288 | 160946 | 162540 | 163754 | 165121 |
| 114 | Gabon | 9254 | 9254 | 9254 | 9283 | 9283 | 9310 | 9310 |
| 115 | Gambia | 3654 | 3656 | 3656 | 3656 | 3659 | 3659 | 3659 |
| 116 | Georgia | 171526 | 175842 | 180441 | 184668 | 188408 | 191968 | 194705 |
| 117 | Germany | 1095982 | 1107115 | 1123725 | 1147943 | 1171444 | 1197472 | 1220277 |
| 118 | Ghana | 52331 | 52331 | 52331 | 52675 | 52675 | 52777 | 52777 |
| 119 | Greece | 93764 | 93764 | 93764 | 93764 | 93764 | 93764 | 93764 |
| 120 | Grenada | 41 | 41 | 49 | 49 | 49 | 49 | 49 |
| 121 | Guatemala | 120257 | 120715 | 120994 | 121337 | 121936 | 122438 | 122965 |
| 122 | Guinea | 12859 | 12905 | 12955 | 13001 | 13001 | 13015 | 13039 |
| 123 | Guinea-Bissau | 2378 | 2378 | 2378 | 2378 | 2386 | 2386 | 2386 |
| 124 | Guyana | 5288 | 5305 | 5319 | 5369 | 5385 | 5448 | 5478 |
| 125 | Haiti | 8321 | 8336 | 8336 | 8404 | 8408 | 8413 | 8413 |
| 126 | Holy See | 15 | 15 | 15 | 15 | 15 | 15 | 15 |
| 127 | Honduras | 54002 | 54002 | 54267 | 54304 | 54446 | 54806 | 54806 |
| 128 | Hungary | 89814 | 93323 | 97443 | 102962 | 108676 | 114631 | 120529 |
| 129 | Iceland | 5449 | 5467 | 5478 | 5487 | 5500 | 5506 | 5506 |
| 130 | India | 9550712 | 9580402 | 9606111 | 9636487 | 9663382 | 9693173 | 9717834 |
| 131 | Indonesia | 531995 | 536260 | 541811 | 546884 | 552722 | 558703 | 563980 |
| 132 | Iran | 865474 | 875943 | 885054 | 894366 | 903998 | 914194 | 924685 |
| 133 | Iraq | 517091 | 519005 | 520969 | 522637 | 524344 | 525792 | 527341 |
| 134 | Ireland | 23364 | 23364 | 23364 | 23364 | 23364 | 23364 | 23364 |
| 135 | Israel | 344373 | 345590 | 348107 | 348874 | 351187 | 351876 | 354674 |
| 136 | Italy | 1226086 | 1249470 | 1261626 | 1281258 | 1301573 | 1322067 | 1344785 |
| 137 | Jamaica | 8668 | 8812 | 8966 | 9113 | 9266 | 9416 | 9579 |
| 138 | Japan | 160630 | 163152 | 165177 | 167357 | 169186 | 171959 | 174723 |
| 139 | Jordan | 236550 | 239126 | 243106 | 246168 | 249256 | 252158 | 254496 |
| 140 | Kazakhstan | 162074 | 162959 | 163834 | 164774 | 165950 | 167503 | 168805 |
| 141 | Kenya | 75274 | 75559 | 75735 | 76060 | 76222 | 76508 | 76720 |
| 142 | Korea, South | 34334 | 34722 | 35155 | 35928 | 36726 | 37425 | 38048 |
| 143 | Kosovo | 35792 | 36228 | 36570 | 36775 | 36775 | 37192 | 37192 |
| 144 | Kuwait | 143355 | 143641 | 143926 | 144142 | 144356 | 144594 | 144898 |
| 145 | Kyrgyzstan | 72051 | 72459 | 73005 | 73005 | 73300 | 73561 | 73870 |
| 146 | Laos | 36 | 36 | 36 | 37 | 37 | 37 | 37 |
| 147 | Latvia | 19072 | 20534 | 21051 | 21248 | 21816 | 22523 | 23402 |
| 148 | Lebanon | 106712 | 110535 | 112333 | 113948 | 115124 | 116143 | 117311 |
| 149 | Lesotho | 1445 | 1445 | 1445 | 1445 | 1445 | 1466 | 1466 |
| 150 | Liberia | 1406 | 1406 | 1406 | 1406 | 1406 | 1406 | 1406 |
| 151 | Libya | 63886 | 63886 | 64810 | 65532 | 66076 | 66756 | 67661 |
| 152 | Liechtenstein | 1424 | 1424 | 1424 | 1507 | 1542 | 1591 | 1591 |
| 153 | Lithuania | 46560 | 50587 | 50721 | 50863 | 54197 | 55926 | 60559 |
| 154 | Luxembourg | 35237 | 35237 | 35237 | 37106 | 37221 | 37574 | 37574 |
| 155 | MS Zaandam | 7 | 7 | 7 | 7 | 7 | 7 | 7 |
| 156 | Madagascar | 16992 | 16992 | 17147 | 17147 | 17147 | 17147 | 17147 |
| 157 | Malawi | 5662 | 5662 | 5663 | 5664 | 5668 | 5675 | 5676 |
| 158 | Malaysia | 75244 | 76242 | 77309 | 78393 | 79304 | 80014 | 81099 |
| 159 | Maldives | 12836 | 12878 | 12895 | 12929 | 12960 | 12983 | 13011 |
| 160 | Mali | 3771 | 3794 | 3839 | 3858 | 3884 | 3927 | 3968 |
| 161 | Malta | 9780 | 9881 | 9978 | 10115 | 10161 | 10293 | 10423 |
| 162 | Marshall Islands | 4 | 4 | 4 | 4 | 4 | 4 | 4 |
| 163 | Mauritania | 8426 | 8545 | 8909 | 8909 | 9005 | 9264 | 9490 |
| 164 | Mauritius | 489 | 489 | 489 | 489 | 496 | 496 | 496 |
| 165 | Mexico | 962397 | 971115 | 978002 | 987328 | 996302 | 1005248 | 1015256 |
| 166 | Moldova | 115612 | 117002 | 118635 | 120015 | 121402 | 122614 | 123924 |
| 167 | Monaco | 616 | 616 | 621 | 631 | 636 | 646 | 659 |
| 168 | Mongolia | 509 | 509 | 509 | 541 | 541 | 584 | 584 |
| 169 | Montenegro | 33491 | 33788 | 34082 | 34569 | 35149 | 35482 | 35809 |
| 170 | Morocco | 372725 | 375623 | 378154 | 380134 | 382925 | 385895 | 388728 |
| 171 | Mozambique | 15365 | 15451 | 15454 | 15733 | 15856 | 15856 | 16015 |
| 172 | Namibia | 15626 | 15849 | 15967 | 16041 | 16317 | 16892 | 17198 |
| 173 | Nepal | 241392 | 242567 | 243664 | 244743 | 245709 | 246661 | 247400 |
| 174 | Netherlands | 4928 | 4937 | 4957 | 4969 | 4997 | 5008 | 5031 |
| 175 | Netherlands | 166 | 172 | 172 | 172 | 172 | 174 | 174 |
| 176 | Netherlands | 2210 | 2249 | 2276 | 2284 | 2360 | 2385 | 2430 |
| 177 | Netherlands | 1157 | 1159 | 1184 | 1202 | 1214 | 1235 | 1238 |
| 178 | Netherlands | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 179 | New Zealand | 2034 | 2036 | 2037 | 2037 | 2054 | 2054 | 2054 |
| 180 | Nicaragua | 4225 | 4225 | 4225 | 4225 | 4225 | 4225 | 4225 |
| 181 | Niger | 1377 | 1406 | 1418 | 1432 | 1508 | 1578 | 1579 |
| 182 | Nigeria | 67484 | 67784 | 68303 | 68493 | 68879 | 69274 | 69651 |
| 183 | North Macedonia | 52949 | 53345 | 54034 | 55155 | 56099 | 56743 | 57434 |
| 184 | Norway | 17998 | 17998 | 17998 | 17998 | 17998 | 17998 | 17998 |
| 185 | Oman | 119009 | 119009 | 119574 | 119745 | 119945 | 120178 | 120441 |
| 186 | Pakistan | 404501 | 407405 | 409085 | 410937 | 415352 | 417134 | 418958 |
| 187 | Panama | 170170 | 171745 | 173508 | 174951 | 176428 | 178140 | 180045 |
| 188 | Papua New Guinea | 601 | 601 | 601 | 601 | 601 | 601 | 661 |
| 189 | Paraguay | 70101 | 70943 | 71807 | 72721 | 73646 | 74573 | 75509 |
| 190 | Peru | 928219 | 930410 | 930410 | 932295 | 936182 | 936182 | 938341 |
| 191 | Philippines | 420666 | 421086 | 429134 | 429207 | 429419 | 429972 | 430490 |
| 192 | Poland | 915576 | 927723 | 938269 | 946017 | 954272 | 965178 | 975876 |
| 193 | Portugal | 290690 | 294814 | 297233 | 299603 | 304825 | 308446 | 312533 |
| 194 | Qatar | 139384 | 139521 | 139724 | 139927 | 140129 | 140264 | 140404 |
| 195 | Romania | 484948 | 493379 | 498777 | 501896 | 508979 | 516423 | 523829 |
| 196 | Russia | 2207398 | 2233060 | 2253826 | 2273510 | 2297289 | 2321362 | 2347700 |
| 197 | Rwanda | 6089 | 6089 | 6091 | 6100 | 6163 | 6163 | 6203 |
| 198 | Saint Kitts and Nevis | 24 | 24 | 24 | 25 | 25 | 25 | 26 |
| 199 | Saint Lucia | 253 | 253 | 258 | 261 | 263 | 264 | 267 |
| 200 | Saint Vincent and the Grenadines | 82 | 82 | 85 | 85 | 85 | 85 | 85 |
| 201 | Samoa | 2 | 2 | 2 | 2 | 2 | 2 | 2 |
| 202 | San Marino | 1733 | 1736 | 1736 | 1767 | 1825 | 1846 | 1863 |
| 203 | Sao Tome and Principe | 955 | 958 | 958 | 958 | 958 | 960 | 960 |
| 204 | Saudi Arabia | 351573 | 351722 | 351878 | 352089 | 352249 | 352418 | 352608 |
| 205 | Senegal | 16449 | 16493 | 16522 | 16562 | 16592 | 16657 | 16742 |
| 206 | Serbia | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 207 | Seychelles | 184 | 184 | 184 | 184 | 184 | 184 | 184 |
| 208 | Sierra Leone | 1854 | 1854 | 1856 | 1856 | 1860 | 1866 | 1866 |
| 209 | Singapore | 58265 | 58274 | 58279 | 58287 | 58304 | 58322 | 58332 |
| 210 | Slovakia | 104560 | 106361 | 107828 | 109807 | 110565 | 112627 | 114267 |
| 211 | Slovenia | 80935 | 82541 | 83536 | 83977 | 87960 | 90100 | 91952 |
| 212 | Solomon Islands | 5 | 5 | 5 | 5 | 5 | 5 | 5 |
| 213 | Somalia | 3566 | 3566 | 3566 | 3566 | 3605 | 3605 | 3605 |
| 214 | South Africa | 783818 | 787782 | 793914 | 796346 | 808241 | 811372 | 822978 |
| 215 | South Sudan | 3090 | 3090 | 3090 | 3111 | 3111 | 3118 | 3118 |
| 216 | Spain | 150376 | 150376 | 150376 | 150376 | 150376 | 150376 | 150376 |
| 217 | Sri Lanka | 27061 | 27552 | 28267 | 28682 | 29300 | 29882 | 30568 |
| 218 | Sudan | 12873 | 13024 | 13171 | 13260 | 13524 | 13524 | 13524 |
| 219 | Suriname | 5249 | 5263 | 5291 | 5296 | 5323 | 5345 | 5388 |
| 220 | Sweden | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 221 | Switzerland | 311500 | 311500 | 311500 | 311500 | 311500 | 311500 | 311500 |
| 222 | Syria | 4686 | 4737 | 4786 | 4835 | 4885 | 4927 | 4997 |
| 223 | Taiwan* | 619 | 625 | 627 | 627 | 632 | 635 | 635 |
| 224 | Tajikistan | 12333 | 12374 | 12413 | 12455 | 12496 | 12536 | 12578 |
| 225 | Tanzania | 183 | 183 | 183 | 183 | 183 | 183 | 183 |
| 226 | Thailand | 4024 | 4041 | 4053 | 4078 | 4078 | 4095 | 4130 |
| 227 | Timor-Leste | 30 | 35 | 31 | 31 | 31 | 31 | 31 |
| 228 | Togo | 2933 | 2974 | 3017 | 3054 | 3091 | 3131 | 3186 |
| 229 | Trinidad and Tobago | 6405 | 6426 | 6457 | 6471 | 6488 | 6495 | 6503 |
| 230 | Tunisia | 87884 | 87884 | 87884 | 87884 | 95763 | 97026 | 97776 |
| 231 | Turkey | 1753552 | 1779068 | 1800286 | 1834705 | 1866815 | 1901307 | 1935292 |
| 232 | US | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 233 | Uganda | 10251 | 10360 | 10469 | 10549 | 10646 | 10731 | 10821 |
| 234 | Ukraine | 582457 | 596218 | 602993 | 608120 | 622519 | 638265 | 654592 |
| 235 | United Arab Emirates | 167306 | 168129 | 168995 | 169840 | 171451 | 172984 | 174479 |
| 236 | United Kingdom | 10 | 10 | 10 | 10 | 10 | 10 | 10 |
| 237 | United Kingdom | 261 | 267 | 276 | 276 | 291 | 321 | 338 |
| 238 | United Kingdom | 73 | 74 | 74 | 74 | 74 | 74 | 74 |
| 239 | United Kingdom | 282 | 282 | 282 | 288 | 288 | 290 | 290 |
| 240 | United Kingdom | 1470 | 1535 | 1535 | 1535 | 1535 | 1817 | 1898 |
| 241 | United Kingdom | 17 | 17 | 17 | 17 | 17 | 17 | 17 |
| 242 | United Kingdom | 1054 | 1058 | 1065 | 1069 | 1075 | 1075 | 1075 |
| 243 | United Kingdom | 344 | 344 | 345 | 346 | 346 | 346 | 346 |
| 244 | United Kingdom | 12 | 12 | 12 | 12 | 12 | 12 | 12 |
| 245 | United Kingdom | 741 | 755 | 759 | 759 | 761 | 761 | 761 |
| 246 | United Kingdom | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 247 | Uruguay | 7699 | 8002 | 8327 | 8688 | 9127 | 9574 | 10040 |
| 248 | Uzbekistan | 72961 | 73099 | 73242 | 73339 | 73460 | 73589 | 73746 |
| 249 | Vanuatu | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| 250 | Venezuela | 103975 | 104208 | 104462 | 104799 | 104799 | 105249 | 105479 |
| 251 | Vietnam | 1266 | 1269 | 1269 | 1269 | 1281 | 1281 | 1281 |
| 252 | West Bank and Gaza | 94556 | 96461 | 97979 | 99547 | 101355 | 102942 | 105233 |
| 253 | Yemen | 1384 | 1384 | 1384 | 1384 | 1384 | 1384 | 1384 |
| 254 | Zambia | 17729 | 17756 | 17762 | 17818 | 17890 | 17969 | 18036 |
| 255 | Zimbabwe | 9894 | 9984 | 10024 | 10112 | 10159 | 10259 | 10314 |
deathdf=death_df[death_df.columns[1:2]]
deathdf=pd.concat([deathdf,death_df[death_df.columns[-7:]]],axis=1)
deathdf.head(313)
| Country/Region | 12/18/20 | 12/19/20 | 12/20/20 | 12/21/20 | 12/22/20 | 12/23/20 | 12/24/20 | |
|---|---|---|---|---|---|---|---|---|
| 0 | Afghanistan | 2030 | 2047 | 2067 | 2082 | 2096 | 2117 | 2126 |
| 1 | Albania | 1066 | 1074 | 1088 | 1098 | 1111 | 1117 | 1125 |
| 2 | Algeria | 2647 | 2659 | 2666 | 2675 | 2687 | 2696 | 2705 |
| 3 | Andorra | 80 | 80 | 81 | 81 | 82 | 82 | 83 |
| 4 | Angola | 384 | 386 | 387 | 390 | 393 | 393 | 393 |
| 5 | Antigua and Barbuda | 5 | 5 | 5 | 5 | 5 | 5 | 5 |
| 6 | Argentina | 41672 | 41763 | 41813 | 41997 | 42254 | 42314 | 42314 |
| 7 | Armenia | 2596 | 2616 | 2630 | 2656 | 2673 | 2691 | 2714 |
| 8 | Australia | 3 | 3 | 3 | 3 | 3 | 3 | 3 |
| 9 | Australia | 53 | 53 | 53 | 53 | 53 | 53 | 53 |
| 10 | Australia | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 11 | Australia | 6 | 6 | 6 | 6 | 6 | 6 | 6 |
| 12 | Australia | 4 | 4 | 4 | 4 | 4 | 4 | 4 |
| 13 | Australia | 13 | 13 | 13 | 13 | 13 | 13 | 13 |
| 14 | Australia | 820 | 820 | 820 | 820 | 820 | 820 | 820 |
| 15 | Australia | 9 | 9 | 9 | 9 | 9 | 9 | 9 |
| 16 | Austria | 5127 | 5209 | 5351 | 5435 | 5540 | 5654 | 5745 |
| 17 | Azerbaijan | 2133 | 2175 | 2210 | 2253 | 2294 | 2340 | 2380 |
| 18 | Bahamas | 164 | 164 | 164 | 164 | 169 | 169 | 169 |
| 19 | Bahrain | 349 | 349 | 349 | 350 | 350 | 350 | 350 |
| 20 | Bangladesh | 7217 | 7242 | 7280 | 7312 | 7329 | 7359 | 7378 |
| 21 | Barbados | 7 | 7 | 7 | 7 | 7 | 7 | 7 |
| 22 | Belarus | 1308 | 1316 | 1324 | 1333 | 1341 | 1349 | 1358 |
| 23 | Belgium | 18455 | 18545 | 18626 | 18697 | 18821 | 18939 | 19038 |
| 24 | Belize | 213 | 213 | 213 | 224 | 226 | 226 | 228 |
| 25 | Benin | 44 | 44 | 44 | 44 | 44 | 44 | 44 |
| 26 | Bhutan | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 27 | Bolivia | 9033 | 9035 | 9036 | 9043 | 9052 | 9065 | 9076 |
| 28 | Bosnia and Herzegovina | 3583 | 3625 | 3625 | 3706 | 3792 | 3838 | 3878 |
| 29 | Botswana | 38 | 38 | 38 | 38 | 38 | 38 | 40 |
| 30 | Brazil | 185650 | 186356 | 186764 | 187291 | 188259 | 189220 | 189982 |
| 31 | Brunei | 3 | 3 | 3 | 3 | 3 | 3 | 3 |
| 32 | Bulgaria | 6496 | 6551 | 6609 | 6765 | 6879 | 6978 | 7023 |
| 33 | Burkina Faso | 74 | 74 | 76 | 76 | 77 | 77 | 77 |
| 34 | Burma | 2398 | 2424 | 2443 | 2465 | 2484 | 2507 | 2532 |
| 35 | Burundi | 1 | 2 | 2 | 2 | 2 | 2 | 2 |
| 36 | Cabo Verde | 110 | 111 | 111 | 111 | 112 | 112 | 112 |
| 37 | Cambodia | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 38 | Cameroon | 445 | 445 | 448 | 448 | 448 | 448 | 448 |
| 39 | Canada | 815 | 841 | 851 | 860 | 871 | 890 | 890 |
| 40 | Canada | 724 | 724 | 724 | 765 | 777 | 796 | 808 |
| 41 | Canada | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| 42 | Canada | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 43 | Canada | 547 | 556 | 569 | 572 | 590 | 605 | 617 |
| 44 | Canada | 8 | 8 | 8 | 8 | 8 | 8 | 8 |
| 45 | Canada | 4 | 4 | 4 | 4 | 4 | 4 | 4 |
| 46 | Canada | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 47 | Canada | 65 | 65 | 65 | 65 | 65 | 65 | 65 |
| 48 | Canada | 0 | 0 | 1 | 1 | 1 | 1 | 1 |
| 49 | Canada | 4112 | 4141 | 4167 | 4181 | 4207 | 4248 | 4303 |
| 50 | Canada | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 51 | Canada | 7671 | 7715 | 7736 | 7766 | 7794 | 7867 | 7913 |
| 52 | Canada | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 53 | Canada | 107 | 115 | 118 | 122 | 125 | 130 | 134 |
| 54 | Canada | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| 55 | Central African Republic | 63 | 63 | 63 | 63 | 63 | 63 | 63 |
| 56 | Chad | 102 | 102 | 102 | 102 | 102 | 102 | 102 |
| 57 | Chile | 16051 | 16101 | 16154 | 16197 | 16217 | 16228 | 16303 |
| 58 | China | 6 | 6 | 6 | 6 | 6 | 6 | 6 |
| 59 | China | 9 | 9 | 9 | 9 | 9 | 9 | 9 |
| 60 | China | 6 | 6 | 6 | 6 | 6 | 6 | 6 |
| 61 | China | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| 62 | China | 2 | 2 | 2 | 2 | 2 | 2 | 2 |
| 63 | China | 8 | 8 | 8 | 8 | 8 | 8 | 8 |
| 64 | China | 2 | 2 | 2 | 2 | 2 | 2 | 2 |
| 65 | China | 2 | 2 | 2 | 2 | 2 | 2 | 2 |
| 66 | China | 6 | 6 | 6 | 6 | 6 | 6 | 6 |
| 67 | China | 6 | 6 | 6 | 6 | 6 | 6 | 6 |
| 68 | China | 13 | 13 | 13 | 13 | 13 | 13 | 13 |
| 69 | China | 22 | 22 | 22 | 22 | 22 | 22 | 22 |
| 70 | China | 129 | 129 | 130 | 131 | 132 | 133 | 135 |
| 71 | China | 4512 | 4512 | 4512 | 4512 | 4512 | 4512 | 4512 |
| 72 | China | 4 | 4 | 4 | 4 | 4 | 4 | 4 |
| 73 | China | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| 74 | China | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 75 | China | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| 76 | China | 2 | 2 | 2 | 2 | 2 | 2 | 2 |
| 77 | China | 2 | 2 | 2 | 2 | 2 | 2 | 2 |
| 78 | China | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 79 | China | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 80 | China | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 81 | China | 3 | 3 | 3 | 3 | 3 | 3 | 3 |
| 82 | China | 7 | 7 | 7 | 7 | 7 | 7 | 7 |
| 83 | China | 7 | 7 | 7 | 7 | 7 | 7 | 7 |
| 84 | China | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 85 | China | 3 | 3 | 3 | 3 | 3 | 3 | 3 |
| 86 | China | 3 | 3 | 3 | 3 | 3 | 3 | 3 |
| 87 | China | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 88 | China | 3 | 3 | 3 | 3 | 3 | 3 | 3 |
| 89 | China | 2 | 2 | 2 | 2 | 2 | 2 | 2 |
| 90 | China | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| 91 | Colombia | 40019 | 40268 | 40475 | 40680 | 40931 | 41174 | 41454 |
| 92 | Comoros | 7 | 7 | 7 | 7 | 7 | 7 | 7 |
| 93 | Congo (Brazzaville) | 100 | 100 | 100 | 100 | 100 | 100 | 100 |
| 94 | Congo (Kinshasa) | 366 | 369 | 370 | 370 | 370 | 566 | 573 |
| 95 | Costa Rica | 1996 | 1996 | 1996 | 2037 | 2051 | 2065 | 2086 |
| 96 | Cote d'Ivoire | 133 | 133 | 133 | 133 | 133 | 133 | 133 |
| 97 | Croatia | 3023 | 3101 | 3177 | 3257 | 3328 | 3394 | 3464 |
| 98 | Cuba | 137 | 137 | 137 | 137 | 139 | 139 | 139 |
| 99 | Cyprus | 85 | 89 | 91 | 96 | 96 | 104 | 107 |
| 100 | Czechia | 10163 | 10271 | 10331 | 10411 | 10562 | 10664 | 10776 |
| 101 | Denmark | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 102 | Denmark | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 103 | Denmark | 1007 | 1019 | 1035 | 1053 | 1070 | 1096 | 1114 |
| 104 | Diamond Princess | 13 | 13 | 13 | 13 | 13 | 13 | 13 |
| 105 | Djibouti | 61 | 61 | 61 | 61 | 61 | 61 | 61 |
| 106 | Dominica | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 107 | Dominican Republic | 2376 | 2382 | 2384 | 2385 | 2398 | 2401 | 2404 |
| 108 | Ecuador | 13942 | 13948 | 13948 | 13949 | 13949 | 13962 | 13977 |
| 109 | Egypt | 7041 | 7069 | 7098 | 7130 | 7167 | 7209 | 7260 |
| 110 | El Salvador | 1234 | 1242 | 1250 | 1257 | 1265 | 1274 | 1283 |
| 111 | Equatorial Guinea | 85 | 85 | 85 | 85 | 85 | 85 | 85 |
| 112 | Eritrea | 0 | 0 | 0 | 0 | 1 | 1 | 1 |
| 113 | Estonia | 168 | 170 | 174 | 181 | 187 | 192 | 195 |
| 114 | Eswatini | 136 | 137 | 140 | 141 | 142 | 153 | 154 |
| 115 | Ethiopia | 1843 | 1846 | 1853 | 1861 | 1864 | 1870 | 1882 |
| 116 | Fiji | 2 | 2 | 2 | 2 | 2 | 2 | 2 |
| 117 | Finland | 489 | 489 | 489 | 506 | 511 | 524 | 524 |
| 118 | France | 71 | 71 | 71 | 71 | 71 | 71 | 71 |
| 119 | France | 103 | 103 | 103 | 106 | 106 | 107 | 108 |
| 120 | France | 152 | 154 | 155 | 155 | 155 | 155 | 155 |
| 121 | France | 42 | 42 | 42 | 42 | 42 | 42 | 42 |
| 122 | France | 53 | 53 | 53 | 53 | 53 | 54 | 54 |
| 123 | France | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 124 | France | 42 | 42 | 42 | 42 | 42 | 42 | 42 |
| 125 | France | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| 126 | France | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 127 | France | 12 | 12 | 12 | 12 | 12 | 12 | 12 |
| 128 | France | 59869 | 60056 | 60186 | 60537 | 61339 | 61614 | 61904 |
| 129 | Gabon | 64 | 64 | 64 | 64 | 64 | 64 | 64 |
| 130 | Gambia | 123 | 123 | 123 | 123 | 123 | 123 | 123 |
| 131 | Georgia | 2002 | 2055 | 2094 | 2140 | 2182 | 2233 | 2276 |
| 132 | Germany | 25754 | 26171 | 26400 | 27110 | 28096 | 28909 | 29330 |
| 133 | Ghana | 331 | 331 | 331 | 333 | 333 | 333 | 333 |
| 134 | Greece | 4044 | 4102 | 4172 | 4257 | 4340 | 4402 | 4457 |
| 135 | Grenada | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 136 | Guatemala | 4589 | 4624 | 4656 | 4688 | 4718 | 4739 | 4749 |
| 137 | Guinea | 80 | 80 | 80 | 80 | 80 | 80 | 80 |
| 138 | Guinea-Bissau | 44 | 44 | 44 | 44 | 45 | 45 | 45 |
| 139 | Guyana | 159 | 159 | 159 | 159 | 160 | 162 | 162 |
| 140 | Haiti | 234 | 234 | 234 | 234 | 234 | 234 | 234 |
| 141 | Holy See | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 142 | Honduras | 3023 | 3023 | 3027 | 3034 | 3046 | 3054 | 3054 |
| 143 | Hungary | 7725 | 7914 | 8099 | 8282 | 8462 | 8616 | 8729 |
| 144 | Iceland | 28 | 28 | 28 | 28 | 28 | 28 | 28 |
| 145 | India | 145136 | 145477 | 145810 | 146111 | 146444 | 146756 | 147092 |
| 146 | Indonesia | 19514 | 19659 | 19880 | 20085 | 20257 | 20408 | 20589 |
| 147 | Iran | 53273 | 53448 | 53625 | 53816 | 54003 | 54156 | 54308 |
| 148 | Iraq | 12670 | 12680 | 12697 | 12710 | 12725 | 12737 | 12744 |
| 149 | Ireland | 2149 | 2154 | 2158 | 2158 | 2171 | 2184 | 2192 |
| 150 | Israel | 3057 | 3074 | 3099 | 3111 | 3136 | 3150 | 3171 |
| 151 | Italy | 67894 | 68447 | 68799 | 69214 | 69842 | 70395 | 70900 |
| 152 | Jamaica | 283 | 285 | 286 | 286 | 288 | 290 | 292 |
| 153 | Japan | 2709 | 2749 | 2784 | 2833 | 2877 | 2941 | 2967 |
| 154 | Jordan | 3518 | 3545 | 3568 | 3604 | 3627 | 3652 | 3681 |
| 155 | Kazakhstan | 2617 | 2621 | 2622 | 2626 | 2677 | 2677 | 2677 |
| 156 | Kenya | 1629 | 1633 | 1639 | 1644 | 1647 | 1648 | 1652 |
| 157 | Korea, South | 659 | 674 | 698 | 722 | 739 | 756 | 773 |
| 158 | Kosovo | 1240 | 1248 | 1256 | 1262 | 1262 | 1274 | 1274 |
| 159 | Kuwait | 916 | 918 | 921 | 922 | 923 | 924 | 926 |
| 160 | Kyrgyzstan | 1324 | 1328 | 1331 | 1331 | 1335 | 1337 | 1340 |
| 161 | Laos | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 162 | Latvia | 409 | 427 | 439 | 443 | 459 | 479 | 486 |
| 163 | Lebanon | 1259 | 1270 | 1281 | 1294 | 1311 | 1333 | 1353 |
| 164 | Lesotho | 48 | 48 | 48 | 48 | 48 | 51 | 51 |
| 165 | Liberia | 83 | 83 | 83 | 83 | 83 | 83 | 83 |
| 166 | Libya | 1346 | 1346 | 1353 | 1369 | 1385 | 1393 | 1399 |
| 167 | Liechtenstein | 23 | 25 | 25 | 27 | 28 | 30 | 30 |
| 168 | Lithuania | 972 | 1005 | 1019 | 1039 | 1093 | 1143 | 1186 |
| 169 | Luxembourg | 434 | 434 | 434 | 450 | 453 | 458 | 458 |
| 170 | MS Zaandam | 2 | 2 | 2 | 2 | 2 | 2 | 2 |
| 171 | Madagascar | 259 | 259 | 260 | 260 | 260 | 260 | 260 |
| 172 | Malawi | 187 | 187 | 187 | 187 | 187 | 187 | 187 |
| 173 | Malaysia | 432 | 433 | 437 | 438 | 439 | 444 | 446 |
| 174 | Maldives | 48 | 48 | 48 | 48 | 48 | 48 | 48 |
| 175 | Mali | 215 | 220 | 222 | 225 | 225 | 229 | 235 |
| 176 | Malta | 183 | 187 | 190 | 194 | 196 | 201 | 203 |
| 177 | Marshall Islands | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 178 | Mauritania | 264 | 273 | 281 | 286 | 290 | 297 | 301 |
| 179 | Mauritius | 10 | 10 | 10 | 10 | 10 | 10 | 10 |
| 180 | Mexico | 117249 | 117876 | 118202 | 118598 | 119495 | 120311 | 121172 |
| 181 | Moldova | 2700 | 2727 | 2752 | 2777 | 2803 | 2825 | 2848 |
| 182 | Monaco | 3 | 3 | 3 | 3 | 3 | 3 | 3 |
| 183 | Mongolia | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 184 | Montenegro | 620 | 624 | 626 | 630 | 637 | 639 | 648 |
| 185 | Morocco | 6854 | 6909 | 6957 | 7000 | 7030 | 7086 | 7130 |
| 186 | Mozambique | 146 | 147 | 148 | 149 | 150 | 150 | 156 |
| 187 | Namibia | 169 | 171 | 177 | 180 | 181 | 183 | 187 |
| 188 | Nepal | 1765 | 1777 | 1788 | 1795 | 1798 | 1803 | 1808 |
| 189 | Netherlands | 47 | 47 | 47 | 47 | 47 | 47 | 47 |
| 190 | Netherlands | 3 | 3 | 3 | 3 | 3 | 3 | 3 |
| 191 | Netherlands | 11 | 11 | 11 | 11 | 11 | 12 | 12 |
| 192 | Netherlands | 26 | 26 | 26 | 26 | 26 | 26 | 26 |
| 193 | Netherlands | 10405 | 10459 | 10491 | 10519 | 10633 | 10737 | 10826 |
| 194 | New Zealand | 25 | 25 | 25 | 25 | 25 | 25 | 25 |
| 195 | Nicaragua | 163 | 163 | 163 | 163 | 163 | 164 | 164 |
| 196 | Niger | 85 | 86 | 87 | 87 | 89 | 89 | 90 |
| 197 | Nigeria | 1212 | 1218 | 1221 | 1227 | 1231 | 1236 | 1242 |
| 198 | North Macedonia | 2254 | 2274 | 2292 | 2314 | 2340 | 2354 | 2375 |
| 199 | Norway | 404 | 404 | 404 | 405 | 405 | 421 | 421 |
| 200 | Oman | 1483 | 1483 | 1488 | 1489 | 1490 | 1491 | 1491 |
| 201 | Pakistan | 9250 | 9330 | 9392 | 9474 | 9557 | 9668 | 9753 |
| 202 | Panama | 3504 | 3527 | 3566 | 3597 | 3632 | 3664 | 3715 |
| 203 | Papua New Guinea | 8 | 8 | 8 | 9 | 9 | 9 | 9 |
| 204 | Paraguay | 2050 | 2072 | 2088 | 2103 | 2120 | 2138 | 2154 |
| 205 | Peru | 36858 | 36858 | 37034 | 37103 | 37173 | 37218 | 37218 |
| 206 | Philippines | 8875 | 8911 | 8947 | 8957 | 9021 | 9048 | 9055 |
| 207 | Poland | 24771 | 25254 | 25397 | 25474 | 25783 | 26255 | 26752 |
| 208 | Portugal | 5977 | 6063 | 6134 | 6191 | 6254 | 6343 | 6413 |
| 209 | Qatar | 242 | 243 | 243 | 243 | 243 | 243 | 243 |
| 210 | Romania | 14157 | 14296 | 14394 | 14481 | 14636 | 14766 | 14912 |
| 211 | Russia | 49170 | 49744 | 50242 | 50723 | 51274 | 51810 | 52434 |
| 212 | Rwanda | 57 | 59 | 63 | 65 | 66 | 66 | 69 |
| 213 | Saint Kitts and Nevis | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 214 | Saint Lucia | 5 | 5 | 5 | 5 | 5 | 5 | 5 |
| 215 | Saint Vincent and the Grenadines | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 216 | Samoa | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 217 | San Marino | 55 | 55 | 55 | 55 | 56 | 56 | 56 |
| 218 | Sao Tome and Principe | 17 | 17 | 17 | 17 | 17 | 17 | 17 |
| 219 | Saudi Arabia | 6101 | 6112 | 6122 | 6131 | 6139 | 6148 | 6159 |
| 220 | Senegal | 357 | 361 | 365 | 371 | 372 | 378 | 381 |
| 221 | Serbia | 2580 | 2632 | 2686 | 2733 | 2782 | 2833 | 2882 |
| 222 | Seychelles | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 223 | Sierra Leone | 75 | 75 | 75 | 75 | 75 | 76 | 76 |
| 224 | Singapore | 29 | 29 | 29 | 29 | 29 | 29 | 29 |
| 225 | Slovakia | 1440 | 1510 | 1555 | 1618 | 1618 | 1686 | 1732 |
| 226 | Slovenia | 2274 | 2314 | 2353 | 2379 | 2418 | 2454 | 2479 |
| 227 | Solomon Islands | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 228 | Somalia | 124 | 124 | 124 | 124 | 127 | 127 | 127 |
| 229 | South Africa | 24285 | 24539 | 24691 | 24907 | 25246 | 25657 | 25983 |
| 230 | South Sudan | 62 | 62 | 62 | 62 | 62 | 62 | 62 |
| 231 | Spain | 48926 | 48926 | 48926 | 49260 | 49520 | 49698 | 49824 |
| 232 | Sri Lanka | 165 | 171 | 176 | 181 | 183 | 184 | 185 |
| 233 | Sudan | 1408 | 1425 | 1434 | 1450 | 1468 | 1468 | 1468 |
| 234 | Suriname | 117 | 118 | 118 | 118 | 118 | 118 | 118 |
| 235 | Sweden | 7993 | 7993 | 7993 | 7993 | 8167 | 8279 | 8279 |
| 236 | Switzerland | 6561 | 6602 | 6622 | 6781 | 6924 | 7029 | 7098 |
| 237 | Syria | 591 | 601 | 610 | 621 | 630 | 641 | 652 |
| 238 | Taiwan* | 7 | 7 | 7 | 7 | 7 | 7 | 7 |
| 239 | Tajikistan | 89 | 89 | 89 | 89 | 89 | 89 | 89 |
| 240 | Tanzania | 21 | 21 | 21 | 21 | 21 | 21 | 21 |
| 241 | Thailand | 60 | 60 | 60 | 60 | 60 | 60 | 60 |
| 242 | Timor-Leste | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 243 | Togo | 66 | 66 | 66 | 66 | 66 | 68 | 68 |
| 244 | Trinidad and Tobago | 123 | 123 | 123 | 125 | 125 | 125 | 125 |
| 245 | Tunisia | 4090 | 4126 | 4158 | 4199 | 4237 | 4275 | 4324 |
| 246 | Turkey | 17610 | 17851 | 18097 | 18351 | 18602 | 18861 | 19115 |
| 247 | US | 313610 | 316159 | 317668 | 319364 | 322765 | 326124 | 329023 |
| 248 | Uganda | 230 | 230 | 231 | 238 | 238 | 245 | 245 |
| 249 | Ukraine | 16848 | 17072 | 17201 | 17293 | 17535 | 17823 | 18057 |
| 250 | United Arab Emirates | 630 | 634 | 637 | 639 | 642 | 645 | 647 |
| 251 | United Kingdom | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 252 | United Kingdom | 9 | 9 | 9 | 9 | 9 | 9 | 9 |
| 253 | United Kingdom | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| 254 | United Kingdom | 2 | 2 | 2 | 2 | 2 | 2 | 2 |
| 255 | United Kingdom | 49 | 52 | 52 | 52 | 52 | 56 | 57 |
| 256 | United Kingdom | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 257 | United Kingdom | 6 | 6 | 6 | 6 | 6 | 6 | 6 |
| 258 | United Kingdom | 25 | 25 | 25 | 25 | 25 | 25 | 25 |
| 259 | United Kingdom | 1 | 1 | 1 | 1 | 1 | 1 | 1 |
| 260 | United Kingdom | 6 | 6 | 6 | 6 | 6 | 6 | 6 |
| 261 | United Kingdom | 66541 | 67075 | 67401 | 67616 | 68307 | 69051 | 69625 |
| 262 | Uruguay | 109 | 114 | 119 | 119 | 120 | 128 | 135 |
| 263 | Uzbekistan | 612 | 612 | 612 | 612 | 612 | 612 | 612 |
| 264 | Vanuatu | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
| 265 | Venezuela | 979 | 984 | 988 | 993 | 997 | 1002 | 1006 |
| 266 | Vietnam | 35 | 35 | 35 | 35 | 35 | 35 | 35 |
| 267 | West Bank and Gaza | 1097 | 1117 | 1141 | 1169 | 1198 | 1226 | 1243 |
| 268 | Yemen | 606 | 606 | 606 | 606 | 606 | 606 | 606 |
| 269 | Zambia | 373 | 373 | 373 | 375 | 379 | 380 | 381 |
| 270 | Zimbabwe | 316 | 318 | 320 | 322 | 326 | 330 | 339 |
country_df.head(n=313)
| Country_Region | Last_Update | Lat | Long_ | Confirmed | Deaths | Recovered | Active | Incident_Rate | People_Tested | People_Hospitalized | Mortality_Rate | UID | ISO3 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 0 | Afghanistan | 2020-12-25 08:22:41 | 33.939110 | 67.709953 | 50810.0 | 2139.0 | 40444.0 | 8227.0 | 130.521874 | NaN | NaN | 4.209801 | 4 | AFG |
| 1 | Albania | 2020-12-25 08:22:41 | 41.153300 | 20.168300 | 54827.0 | 1125.0 | 30276.0 | 23426.0 | 1905.170616 | NaN | NaN | 2.051909 | 8 | ALB |
| 2 | Algeria | 2020-12-25 08:22:41 | 28.033900 | 1.659600 | 97007.0 | 2705.0 | 64777.0 | 29525.0 | 221.219368 | NaN | NaN | 2.788459 | 12 | DZA |
| 3 | Andorra | 2020-12-25 08:22:41 | 42.506300 | 1.521800 | 7699.0 | 83.0 | 7171.0 | 445.0 | 9964.408206 | NaN | NaN | 1.078062 | 20 | AND |
| 4 | Angola | 2020-12-25 08:22:41 | -11.202700 | 17.873900 | 17029.0 | 393.0 | 9729.0 | 6907.0 | 51.813002 | NaN | NaN | 2.307828 | 24 | AGO |
| 5 | Antigua and Barbuda | 2020-12-25 08:22:41 | 17.060800 | -61.796400 | 154.0 | 5.0 | 146.0 | 3.0 | 157.258394 | NaN | NaN | 3.246753 | 28 | ATG |
| 6 | Argentina | 2020-12-25 08:22:41 | -38.416100 | -63.616700 | 1571680.0 | 42392.0 | 1384277.0 | 145011.0 | 3477.493041 | NaN | NaN | 2.697241 | 32 | ARG |
| 7 | Armenia | 2020-12-25 08:22:41 | 40.069100 | 45.038200 | 156763.0 | 2733.0 | 137815.0 | 16215.0 | 5290.267323 | NaN | NaN | 1.743396 | 51 | ARM |
| 8 | Australia | 2020-12-25 08:22:41 | -25.000000 | 133.000000 | 28276.0 | 908.0 | 25726.0 | 1642.0 | 111.061796 | NaN | NaN | 3.211204 | 36 | AUS |
| 9 | Austria | 2020-12-25 08:22:41 | 47.516200 | 14.550100 | 347204.0 | 5745.0 | 315952.0 | 25507.0 | 3855.080831 | NaN | NaN | 1.654647 | 40 | AUT |
| 10 | Azerbaijan | 2020-12-25 08:22:41 | 40.143100 | 47.576900 | 210061.0 | 2380.0 | 155886.0 | 51795.0 | 2071.776057 | NaN | NaN | 1.133004 | 31 | AZE |
| 11 | Bahamas | 2020-12-25 08:22:41 | 25.025885 | -78.035889 | 7788.0 | 169.0 | 6166.0 | 1453.0 | 1980.429653 | NaN | NaN | 2.170005 | 44 | BHS |
| 12 | Bahrain | 2020-12-25 08:22:41 | 26.027500 | 50.550000 | 91070.0 | 350.0 | 88963.0 | 1757.0 | 5352.075097 | NaN | NaN | 0.384320 | 48 | BHR |
| 13 | Bangladesh | 2020-12-25 08:22:41 | 23.685000 | 90.356300 | 506102.0 | 7378.0 | 446690.0 | 52034.0 | 307.306999 | NaN | NaN | 1.457809 | 50 | BGD |
| 14 | Barbados | 2020-12-25 08:22:41 | 13.193900 | -59.543200 | 345.0 | 7.0 | 291.0 | 47.0 | 120.053868 | NaN | NaN | 2.028986 | 52 | BRB |
| 15 | Belarus | 2020-12-25 08:22:41 | 53.709800 | 27.953400 | 181113.0 | 1358.0 | 159437.0 | 20318.0 | 1916.677399 | NaN | NaN | 0.749808 | 112 | BLR |
| 16 | Belgium | 2020-12-25 08:22:41 | 50.833300 | 4.469936 | 634904.0 | 19038.0 | NaN | 615866.0 | 5478.214291 | NaN | NaN | 2.998564 | 56 | BEL |
| 17 | Belize | 2020-12-25 08:22:41 | 17.189900 | -88.497600 | 10490.0 | 228.0 | 9081.0 | 1181.0 | 2638.190639 | NaN | NaN | 2.173499 | 84 | BLZ |
| 18 | Benin | 2020-12-25 08:22:41 | 9.307700 | 2.315800 | 3205.0 | 44.0 | 3061.0 | 100.0 | 26.436919 | NaN | NaN | 1.372855 | 204 | BEN |
| 19 | Bhutan | 2020-12-25 08:22:41 | 27.514200 | 90.433600 | 541.0 | 0.0 | 442.0 | 99.0 | 70.112958 | NaN | NaN | 0.000000 | 64 | BTN |
| 20 | Bolivia | 2020-12-25 08:22:41 | -16.290200 | -63.588700 | 153121.0 | 9076.0 | 129387.0 | 14658.0 | 1311.750361 | NaN | NaN | 5.927339 | 68 | BOL |
| 21 | Bosnia and Herzegovina | 2020-12-25 08:22:41 | 43.915900 | 17.679100 | 108298.0 | 3878.0 | 73896.0 | 30524.0 | 3300.948088 | NaN | NaN | 3.580860 | 70 | BIH |
| 22 | Botswana | 2020-12-25 08:22:41 | -22.328500 | 24.684900 | 14025.0 | 40.0 | 11627.0 | 2358.0 | 596.396109 | NaN | NaN | 0.285205 | 72 | BWA |
| 23 | Brazil | 2020-12-25 08:22:41 | -14.235000 | -51.925300 | 7423945.0 | 189982.0 | 6512717.0 | 721246.0 | 3492.644732 | NaN | NaN | 2.559044 | 76 | BRA |
| 24 | Brunei | 2020-12-25 08:22:41 | 4.535300 | 114.727700 | 152.0 | 3.0 | 149.0 | 0.0 | 34.744207 | NaN | NaN | 1.973684 | 96 | BRN |
| 25 | Bulgaria | 2020-12-25 08:22:41 | 42.733900 | 25.485800 | 196658.0 | 7023.0 | 107680.0 | 81955.0 | 2830.244753 | NaN | NaN | 3.571174 | 100 | BGR |
| 26 | Burkina Faso | 2020-12-25 08:22:41 | 12.238300 | -1.561600 | 5941.0 | 77.0 | 4129.0 | 1735.0 | 28.421380 | NaN | NaN | 1.296078 | 854 | BFA |
| 27 | Burma | 2020-12-25 08:22:41 | 21.916200 | 95.956000 | 119788.0 | 2532.0 | 99927.0 | 17329.0 | 220.158893 | NaN | NaN | 2.113734 | 104 | MMR |
| 28 | Burundi | 2020-12-25 08:22:41 | -3.373100 | 29.918900 | 773.0 | 2.0 | 687.0 | 84.0 | 6.500835 | NaN | NaN | 0.258732 | 108 | BDI |
| 29 | Cabo Verde | 2020-12-25 08:22:41 | 16.538800 | -23.041800 | 11688.0 | 112.0 | 11366.0 | 210.0 | 2102.203645 | NaN | NaN | 0.958248 | 132 | CPV |
| 30 | Cambodia | 2020-12-25 08:22:41 | 11.550000 | 104.916700 | 363.0 | 0.0 | 354.0 | 9.0 | 2.171186 | NaN | NaN | 0.000000 | 116 | KHM |
| 31 | Cameroon | 2020-12-25 08:22:41 | 3.848000 | 11.502100 | 26277.0 | 448.0 | 24892.0 | 937.0 | 98.987172 | NaN | NaN | 1.704913 | 120 | CMR |
| 32 | Canada | 2020-12-25 08:22:41 | 60.001000 | -95.001000 | 538183.0 | 14745.0 | 448119.0 | 75319.0 | 1421.669581 | NaN | NaN | 2.739774 | 124 | CAN |
| 33 | Central African Republic | 2020-12-25 08:22:41 | 6.611100 | 20.939400 | 4948.0 | 63.0 | 1924.0 | 2961.0 | 102.448070 | NaN | NaN | 1.273242 | 140 | CAF |
| 34 | Chad | 2020-12-25 08:22:41 | 15.454200 | 18.732200 | 1958.0 | 102.0 | 1651.0 | 205.0 | 11.920229 | NaN | NaN | 5.209397 | 148 | TCD |
| 35 | Chile | 2020-12-25 08:22:41 | -35.675100 | -71.543000 | 594152.0 | 16303.0 | 563457.0 | 14392.0 | 3108.105796 | NaN | NaN | 2.743911 | 152 | CHL |
| 36 | China | 2020-12-25 08:22:41 | 30.592800 | 114.305500 | 95383.0 | 4769.0 | 89205.0 | 1409.0 | 6.790390 | NaN | NaN | 4.999843 | 156 | CHN |
| 37 | Colombia | 2020-12-25 08:22:41 | 4.570900 | -74.297300 | 1559766.0 | 41454.0 | 1417316.0 | 100996.0 | 3065.404076 | NaN | NaN | 2.657706 | 170 | COL |
| 38 | Comoros | 2020-12-25 08:22:41 | -11.645500 | 43.333300 | 715.0 | 7.0 | 626.0 | 82.0 | 82.222184 | NaN | NaN | 0.979021 | 174 | COM |
| 39 | Congo (Brazzaville) | 2020-12-25 08:22:41 | -0.228000 | 15.827700 | 6571.0 | 100.0 | 4988.0 | 1483.0 | 119.081016 | NaN | NaN | 1.521838 | 178 | COG |
| 40 | Congo (Kinshasa) | 2020-12-25 08:22:41 | -4.038300 | 21.758700 | 16282.0 | 573.0 | 13982.0 | 1727.0 | 18.179706 | NaN | NaN | 3.519224 | 180 | COD |
| 41 | Costa Rica | 2020-12-25 08:22:41 | 9.748900 | -83.753400 | 162990.0 | 2086.0 | 128842.0 | 32062.0 | 3199.575039 | NaN | NaN | 1.279833 | 188 | CRI |
| 42 | Cote d'Ivoire | 2020-12-25 08:22:41 | 7.540000 | -5.547100 | 22071.0 | 133.0 | 21629.0 | 309.0 | 83.671127 | NaN | NaN | 0.602601 | 384 | CIV |
| 43 | Croatia | 2020-12-25 08:22:41 | 45.100000 | 15.200000 | 202319.0 | 3464.0 | 183532.0 | 15323.0 | 4928.277520 | NaN | NaN | 1.712148 | 191 | HRV |
| 44 | Cuba | 2020-12-25 08:22:41 | 21.521757 | -77.781167 | 10717.0 | 139.0 | 9378.0 | 1200.0 | 94.617845 | NaN | NaN | 1.297005 | 192 | CUB |
| 45 | Cyprus | 2020-12-25 08:22:41 | 35.126400 | 33.429900 | 19316.0 | 107.0 | 2057.0 | 17152.0 | 1599.852902 | NaN | NaN | 0.553945 | 196 | CYP |
| 46 | Czechia | 2020-12-25 08:22:41 | 49.817500 | 15.473000 | 664863.0 | 10859.0 | 557696.0 | 96308.0 | 6208.461271 | NaN | NaN | 1.633269 | 203 | CZE |
| 47 | Denmark | 2020-12-25 08:22:41 | 56.263900 | 9.501800 | 146927.0 | 1114.0 | 102729.0 | 43084.0 | 2536.634161 | NaN | NaN | 0.758200 | 208 | DNK |
| 48 | Diamond Princess | 2020-12-25 08:22:41 | NaN | NaN | 712.0 | 13.0 | 699.0 | 0.0 | NaN | NaN | NaN | 1.825843 | 9999 | NaN |
| 49 | Djibouti | 2020-12-25 08:22:41 | 11.825100 | 42.590300 | 5800.0 | 61.0 | 5690.0 | 49.0 | 587.043346 | NaN | NaN | 1.051724 | 262 | DJI |
| 50 | Dominica | 2020-12-25 08:22:41 | 15.415000 | -61.371000 | 88.0 | 0.0 | 83.0 | 5.0 | 122.237502 | NaN | NaN | 0.000000 | 212 | DMA |
| 51 | Dominican Republic | 2020-12-25 08:22:41 | 18.735700 | -70.162700 | 163654.0 | 2404.0 | 126732.0 | 34518.0 | 1508.623233 | NaN | NaN | 1.468953 | 214 | DOM |
| 52 | Ecuador | 2020-12-25 08:22:41 | -1.831200 | -78.183400 | 208010.0 | 13977.0 | 181618.0 | 12415.0 | 1178.990493 | NaN | NaN | 6.719388 | 218 | ECU |
| 53 | Egypt | 2020-12-25 08:22:41 | 26.820553 | 30.802498 | 128993.0 | 7260.0 | 108474.0 | 13259.0 | 126.050474 | NaN | NaN | 5.628212 | 818 | EGY |
| 54 | El Salvador | 2020-12-25 08:22:41 | 13.794200 | -88.896500 | 44619.0 | 1289.0 | 39989.0 | 3341.0 | 687.906526 | NaN | NaN | 2.888904 | 222 | SLV |
| 55 | Equatorial Guinea | 2020-12-25 08:22:41 | 1.650800 | 10.267900 | 5236.0 | 85.0 | 5078.0 | 73.0 | 373.204275 | NaN | NaN | 1.623377 | 226 | GNQ |
| 56 | Eritrea | 2020-12-25 08:22:41 | 15.179400 | 39.782300 | 951.0 | 1.0 | 600.0 | 350.0 | 26.815722 | NaN | NaN | 0.105152 | 232 | ERI |
| 57 | Estonia | 2020-12-25 08:22:41 | 58.595300 | 25.013600 | 24009.0 | 195.0 | 15393.0 | 8421.0 | 1809.897787 | NaN | NaN | 0.812195 | 233 | EST |
| 58 | Eswatini | 2020-12-25 08:22:41 | -26.522500 | 31.465900 | 8032.0 | 154.0 | 6952.0 | 926.0 | 692.315914 | NaN | NaN | 1.917331 | 748 | SWZ |
| 59 | Ethiopia | 2020-12-25 08:22:41 | 9.145000 | 40.489700 | 121399.0 | 1882.0 | 106845.0 | 12672.0 | 105.597787 | NaN | NaN | 1.550260 | 231 | ETH |
| 60 | Fiji | 2020-12-25 08:22:41 | -17.713400 | 178.065000 | 46.0 | 2.0 | 44.0 | 0.0 | 5.131386 | NaN | NaN | 4.347826 | 242 | FJI |
| 61 | Finland | 2020-12-25 08:22:41 | 61.924100 | 25.748200 | 34447.0 | 524.0 | 26000.0 | 7923.0 | 621.706429 | NaN | NaN | 1.521177 | 246 | FIN |
| 62 | France | 2020-12-25 08:22:41 | 46.227600 | 2.213700 | 2584333.0 | 62389.0 | 194559.0 | 2327385.0 | 3959.236941 | NaN | NaN | 2.414124 | 250 | FRA |
| 63 | Gabon | 2020-12-25 08:22:41 | -0.803700 | 11.609400 | 9469.0 | 64.0 | 9310.0 | 95.0 | 425.433836 | NaN | NaN | 0.675890 | 266 | GAB |
| 64 | Gambia | 2020-12-25 08:22:41 | 13.443200 | -15.310100 | 3791.0 | 123.0 | 3659.0 | 9.0 | 156.869139 | NaN | NaN | 3.244527 | 270 | GMB |
| 65 | Georgia | 2020-12-25 08:22:41 | 42.315400 | 43.356900 | 218724.0 | 2313.0 | 196220.0 | 20191.0 | 5482.938202 | NaN | NaN | 1.057497 | 268 | GEO |
| 66 | Germany | 2020-12-25 08:22:41 | 51.165691 | 10.451526 | 1630596.0 | 29333.0 | 1220277.0 | 380986.0 | 1946.191481 | NaN | NaN | 1.798913 | 276 | DEU |
| 67 | Ghana | 2020-12-25 08:22:41 | 7.946500 | -1.023200 | 54043.0 | 333.0 | 52777.0 | 933.0 | 173.923006 | NaN | NaN | 0.616176 | 288 | GHA |
| 68 | Greece | 2020-12-25 08:22:41 | 39.074200 | 21.824300 | 134235.0 | 4457.0 | 93764.0 | 36014.0 | 1287.866054 | NaN | NaN | 3.320296 | 300 | GRC |
| 69 | Grenada | 2020-12-25 08:22:41 | 12.116500 | -61.679000 | 105.0 | 0.0 | 49.0 | 56.0 | 93.317573 | NaN | NaN | 0.000000 | 308 | GRD |
| 70 | Guatemala | 2020-12-25 08:22:41 | 15.783500 | -90.230800 | 134894.0 | 4749.0 | 122965.0 | 7180.0 | 752.942957 | NaN | NaN | 3.520542 | 320 | GTM |
| 71 | Guinea | 2020-12-25 08:22:41 | 9.945600 | -9.696600 | 13630.0 | 80.0 | 13039.0 | 511.0 | 103.786004 | NaN | NaN | 0.586941 | 324 | GIN |
| 72 | Guinea-Bissau | 2020-12-25 08:22:41 | 11.803700 | -15.180400 | 2447.0 | 45.0 | 2386.0 | 16.0 | 124.339557 | NaN | NaN | 1.838987 | 624 | GNB |
| 73 | Guyana | 2020-12-25 08:22:41 | 4.860416 | -58.930180 | 6266.0 | 162.0 | 5478.0 | 626.0 | 796.634455 | NaN | NaN | 2.585381 | 328 | GUY |
| 74 | Haiti | 2020-12-25 08:22:41 | 18.971200 | -72.285200 | 9805.0 | 234.0 | 8413.0 | 1158.0 | 85.989666 | NaN | NaN | 2.386537 | 332 | HTI |
| 75 | Holy See | 2020-12-25 08:22:41 | 41.902900 | 12.453400 | 27.0 | 0.0 | 15.0 | 12.0 | 3337.453646 | NaN | NaN | 0.000000 | 336 | VAT |
| 76 | Honduras | 2020-12-25 08:22:41 | 15.200000 | -86.241900 | 118036.0 | 3054.0 | 54806.0 | 60176.0 | 1191.728133 | NaN | NaN | 2.587346 | 340 | HND |
| 77 | Hungary | 2020-12-25 08:22:41 | 47.162500 | 19.503300 | 311554.0 | 8729.0 | 120529.0 | 182296.0 | 3225.079837 | NaN | NaN | 2.801761 | 348 | HUN |
| 78 | Iceland | 2020-12-25 08:22:41 | 64.963100 | -19.020800 | 5683.0 | 28.0 | 5506.0 | 149.0 | 1665.347985 | NaN | NaN | 0.492698 | 352 | ISL |
| 79 | India | 2020-12-25 08:22:41 | 20.593684 | 78.962880 | 10146845.0 | 147092.0 | 9717834.0 | 281919.0 | 735.276287 | NaN | NaN | 1.449633 | 356 | IND |
| 80 | Indonesia | 2020-12-25 08:22:41 | -0.789300 | 113.921300 | 692838.0 | 20589.0 | 563980.0 | 108269.0 | 253.300975 | NaN | NaN | 2.971690 | 360 | IDN |
| 81 | Iran | 2020-12-25 08:22:41 | 32.427908 | 53.688046 | 1183182.0 | 54308.0 | 924685.0 | 204189.0 | 1408.668177 | NaN | NaN | 4.589995 | 364 | IRN |
| 82 | Iraq | 2020-12-25 08:22:41 | 33.223191 | 43.679291 | 588803.0 | 12744.0 | 527341.0 | 48718.0 | 1463.864643 | NaN | NaN | 2.164391 | 368 | IRQ |
| 83 | Ireland | 2020-12-25 08:22:41 | 53.142400 | -7.692100 | 83073.0 | 2192.0 | 23364.0 | 57517.0 | 1682.390281 | NaN | NaN | 2.638643 | 372 | IRL |
| 84 | Israel | 2020-12-25 08:22:41 | 31.046051 | 34.851612 | 393036.0 | 3171.0 | 356058.0 | 33807.0 | 4540.860011 | NaN | NaN | 0.806796 | 376 | ISR |
| 85 | Italy | 2020-12-25 08:22:41 | 41.871900 | 12.567400 | 2009317.0 | 70900.0 | 1344785.0 | 593632.0 | 3323.281923 | NaN | NaN | 3.528562 | 380 | ITA |
| 86 | Jamaica | 2020-12-25 08:22:41 | 18.109600 | -77.297500 | 12519.0 | 292.0 | 9579.0 | 2648.0 | 422.773365 | NaN | NaN | 2.332455 | 388 | JAM |
| 87 | Japan | 2020-12-25 08:22:41 | 36.204824 | 138.252924 | 212503.0 | 2974.0 | 174723.0 | 34806.0 | 168.017830 | NaN | NaN | 1.399510 | 392 | JPN |
| 88 | Jordan | 2020-12-25 08:22:41 | 31.240000 | 36.510000 | 283690.0 | 3681.0 | 254496.0 | 25513.0 | 2780.418577 | NaN | NaN | 1.297543 | 400 | JOR |
| 89 | Kazakhstan | 2020-12-25 08:22:41 | 48.019600 | 66.923700 | 195303.0 | 2682.0 | 168961.0 | 23660.0 | 1040.134460 | NaN | NaN | 1.373251 | 398 | KAZ |
| 90 | Kenya | 2020-12-25 08:22:41 | -0.023600 | 37.906200 | 95431.0 | 1652.0 | 76720.0 | 17059.0 | 177.475717 | NaN | NaN | 1.731094 | 404 | KEN |
| 91 | Korea, South | 2020-12-25 08:22:41 | 35.907757 | 127.766922 | 54770.0 | 773.0 | 38048.0 | 15949.0 | 106.828307 | NaN | NaN | 1.411357 | 410 | KOR |
| 92 | Kosovo | 2020-12-25 08:22:41 | 42.602636 | 20.902977 | 49440.0 | 1274.0 | 37192.0 | 10974.0 | 2730.939490 | NaN | NaN | 2.576861 | 383 | XKS |
| 93 | Kuwait | 2020-12-25 08:22:41 | 29.311660 | 47.481766 | 149017.0 | 926.0 | 144898.0 | 3193.0 | 3489.399407 | NaN | NaN | 0.621406 | 414 | KWT |
| 94 | Kyrgyzstan | 2020-12-25 08:22:41 | 41.204380 | 74.766098 | 80025.0 | 1340.0 | 74177.0 | 4508.0 | 1226.588860 | NaN | NaN | 1.674477 | 417 | KGZ |
| 95 | Laos | 2020-12-25 08:22:41 | 19.856270 | 102.495496 | 41.0 | 0.0 | 37.0 | 4.0 | 0.563531 | NaN | NaN | 0.000000 | 418 | LAO |
| 96 | Latvia | 2020-12-25 08:22:41 | 56.879600 | 24.603200 | 34754.0 | 486.0 | 23402.0 | 10866.0 | 1842.538604 | NaN | NaN | 1.398400 | 428 | LVA |
| 97 | Lebanon | 2020-12-25 08:22:41 | 33.854700 | 35.862300 | 165933.0 | 1353.0 | 117311.0 | 47269.0 | 2431.095305 | NaN | NaN | 0.815389 | 422 | LBN |
| 98 | Lesotho | 2020-12-25 08:22:41 | -29.610000 | 28.233600 | 2725.0 | 51.0 | 1466.0 | 1208.0 | 127.202589 | NaN | NaN | 1.871560 | 426 | LSO |
| 99 | Liberia | 2020-12-25 08:22:41 | 6.428055 | -9.429499 | 1779.0 | 83.0 | 1406.0 | 290.0 | 35.174251 | NaN | NaN | 4.665542 | 430 | LBR |
| 100 | Libya | 2020-12-25 08:22:41 | 26.335100 | 17.228331 | 97192.0 | 1399.0 | 67661.0 | 28132.0 | 1414.465733 | NaN | NaN | 1.439419 | 434 | LBY |
| 101 | Liechtenstein | 2020-12-25 08:22:41 | 47.140000 | 9.550000 | 1920.0 | 30.0 | 1591.0 | 299.0 | 5034.480950 | NaN | NaN | 1.562500 | 438 | LIE |
| 102 | Lithuania | 2020-12-25 08:22:41 | 55.169400 | 23.881300 | 126581.0 | 1205.0 | 60946.0 | 64430.0 | 4649.796807 | NaN | NaN | 0.951960 | 440 | LTU |
| 103 | Luxembourg | 2020-12-25 08:22:41 | 49.815300 | 6.129600 | 45209.0 | 458.0 | 37574.0 | 7177.0 | 7222.161872 | NaN | NaN | 1.013073 | 442 | LUX |
| 104 | MS Zaandam | 2020-12-25 08:22:41 | NaN | NaN | 9.0 | 2.0 | 7.0 | 0.0 | NaN | NaN | NaN | 22.222222 | 8888 | NaN |
| 105 | Madagascar | 2020-12-25 08:22:41 | -18.766947 | 46.869107 | 17633.0 | 260.0 | 17147.0 | 226.0 | 63.677686 | NaN | NaN | 1.474508 | 450 | MDG |
| 106 | Malawi | 2020-12-25 08:22:41 | -13.254300 | 34.301500 | 6277.0 | 187.0 | 5676.0 | 414.0 | 32.812414 | NaN | NaN | 2.979130 | 454 | MWI |
| 107 | Malaysia | 2020-12-25 08:22:41 | 4.210484 | 101.975766 | 100318.0 | 446.0 | 81099.0 | 18773.0 | 309.948731 | NaN | NaN | 0.444586 | 458 | MYS |
| 108 | Maldives | 2020-12-25 08:22:41 | 3.202800 | 73.220700 | 13558.0 | 48.0 | 13011.0 | 499.0 | 2508.223228 | NaN | NaN | 0.354035 | 462 | MDV |
| 109 | Mali | 2020-12-25 08:22:41 | 17.570692 | -3.996166 | 6441.0 | 235.0 | 3968.0 | 2238.0 | 31.806097 | NaN | NaN | 3.648502 | 466 | MLI |
| 110 | Malta | 2020-12-25 08:22:41 | 35.937500 | 14.375400 | 12062.0 | 203.0 | 10423.0 | 1436.0 | 2731.808515 | NaN | NaN | 1.682971 | 470 | MLT |
| 111 | Marshall Islands | 2020-12-25 08:22:41 | 7.131500 | 171.184500 | 4.0 | 0.0 | 4.0 | 0.0 | 6.847791 | NaN | NaN | 0.000000 | 584 | MHL |
| 112 | Mauritania | 2020-12-25 08:22:41 | 21.007900 | -10.940800 | 13118.0 | 301.0 | 9490.0 | 3327.0 | 282.128156 | NaN | NaN | 2.294557 | 478 | MRT |
| 113 | Mauritius | 2020-12-25 08:22:41 | -20.348404 | 57.552152 | 527.0 | 10.0 | 496.0 | 21.0 | 41.438408 | NaN | NaN | 1.897533 | 480 | MUS |
| 114 | Mexico | 2020-12-25 08:22:41 | 23.634500 | -102.552800 | 1362564.0 | 121172.0 | 1015256.0 | 226136.0 | 1066.233372 | NaN | NaN | 8.892940 | 484 | MEX |
| 115 | Moldova | 2020-12-25 08:22:41 | 47.411600 | 28.369900 | 139435.0 | 2848.0 | 123924.0 | 12663.0 | 3456.526498 | NaN | NaN | 2.042529 | 498 | MDA |
| 116 | Monaco | 2020-12-25 08:22:41 | 43.733300 | 7.416700 | 783.0 | 3.0 | 659.0 | 121.0 | 1995.209459 | NaN | NaN | 0.383142 | 492 | MCO |
| 117 | Mongolia | 2020-12-25 08:22:41 | 46.862500 | 103.846700 | 1075.0 | 0.0 | 584.0 | 491.0 | 32.791466 | NaN | NaN | 0.000000 | 496 | MNG |
| 118 | Montenegro | 2020-12-25 08:22:41 | 42.708678 | 19.374390 | 45423.0 | 648.0 | 35809.0 | 8966.0 | 7232.247772 | NaN | NaN | 1.426590 | 499 | MNE |
| 119 | Morocco | 2020-12-25 08:22:41 | 31.791700 | -7.092600 | 425864.0 | 7130.0 | 388728.0 | 30006.0 | 1153.772858 | NaN | NaN | 1.674243 | 504 | MAR |
| 120 | Mozambique | 2020-12-25 08:22:41 | -18.665695 | 35.529562 | 18031.0 | 156.0 | 16015.0 | 1860.0 | 57.689167 | NaN | NaN | 0.865177 | 508 | MOZ |
| 121 | Namibia | 2020-12-25 08:22:41 | -22.957600 | 18.490400 | 20579.0 | 187.0 | 17198.0 | 3194.0 | 809.904774 | NaN | NaN | 0.908693 | 516 | NAM |
| 122 | Nepal | 2020-12-25 08:22:41 | 28.166700 | 84.250000 | 256592.0 | 1808.0 | 247400.0 | 7384.0 | 880.645539 | NaN | NaN | 0.704621 | 524 | NPL |
| 123 | Netherlands | 2020-12-25 08:22:41 | 52.316700 | 5.550000 | 743493.0 | 10914.0 | 8873.0 | 723706.0 | 4339.063383 | NaN | NaN | 1.467936 | 528 | NLD |
| 124 | New Zealand | 2020-12-25 08:22:41 | -40.900600 | 174.886000 | 2128.0 | 25.0 | 2054.0 | 49.0 | 44.128934 | NaN | NaN | 1.174812 | 554 | NZL |
| 125 | Nicaragua | 2020-12-25 08:22:41 | 12.865416 | -85.207229 | 5991.0 | 164.0 | 4225.0 | 1602.0 | 90.436277 | NaN | NaN | 2.737439 | 558 | NIC |
| 126 | Niger | 2020-12-25 08:22:41 | 17.607789 | 8.081666 | 2933.0 | 90.0 | 1579.0 | 1264.0 | 12.116512 | NaN | NaN | 3.068531 | 562 | NER |
| 127 | Nigeria | 2020-12-25 08:22:41 | 9.082000 | 8.675300 | 81963.0 | 1242.0 | 69651.0 | 11070.0 | 39.760922 | NaN | NaN | 1.515318 | 566 | NGA |
| 128 | North Macedonia | 2020-12-25 08:22:41 | 41.608600 | 21.745300 | 80407.0 | 2375.0 | 57434.0 | 20598.0 | 3859.449548 | NaN | NaN | 2.953723 | 807 | MKD |
| 129 | Norway | 2020-12-25 08:22:41 | 60.472000 | 8.468900 | 45931.0 | 421.0 | 17998.0 | 27512.0 | 847.241278 | NaN | NaN | 0.916592 | 578 | NOR |
| 130 | Oman | 2020-12-25 08:22:41 | 21.512583 | 55.923255 | 128290.0 | 1491.0 | 120441.0 | 6358.0 | 2512.228240 | NaN | NaN | 1.162211 | 512 | OMN |
| 131 | Pakistan | 2020-12-25 08:22:41 | 30.375300 | 69.345100 | 467222.0 | 9753.0 | 418958.0 | 38511.0 | 211.515718 | NaN | NaN | 2.087445 | 586 | PAK |
| 132 | Panama | 2020-12-25 08:22:41 | 8.538000 | -80.782100 | 223674.0 | 3715.0 | 180045.0 | 39914.0 | 5183.917189 | NaN | NaN | 1.660899 | 591 | PAN |
| 133 | Papua New Guinea | 2020-12-25 08:22:41 | -6.314993 | 143.955550 | 780.0 | 9.0 | 661.0 | 110.0 | 8.717980 | NaN | NaN | 1.153846 | 598 | PNG |
| 134 | Paraguay | 2020-12-25 08:22:41 | -23.442500 | -58.443800 | 103329.0 | 2154.0 | 75509.0 | 25666.0 | 1448.700531 | NaN | NaN | 2.084604 | 600 | PRY |
| 135 | Peru | 2020-12-25 08:22:41 | -9.190000 | -75.015200 | 1000153.0 | 37218.0 | 938341.0 | 24594.0 | 3033.354578 | NaN | NaN | 3.721231 | 604 | PER |
| 136 | Philippines | 2020-12-25 08:22:41 | 12.879721 | 121.774017 | 465724.0 | 9055.0 | 430490.0 | 26179.0 | 425.004005 | NaN | NaN | 1.944285 | 608 | PHL |
| 137 | Poland | 2020-12-25 08:22:41 | 51.919400 | 19.145100 | 1239998.0 | 26752.0 | 975876.0 | 237370.0 | 3276.378423 | NaN | NaN | 2.157423 | 616 | POL |
| 138 | Portugal | 2020-12-25 08:22:41 | 39.399900 | -8.224500 | 387636.0 | 6413.0 | 312533.0 | 68690.0 | 3801.580255 | NaN | NaN | 1.654387 | 620 | PRT |
| 139 | Qatar | 2020-12-25 08:22:41 | 25.354800 | 51.183900 | 142605.0 | 243.0 | 140404.0 | 1958.0 | 4949.740720 | NaN | NaN | 0.170401 | 634 | QAT |
| 140 | Romania | 2020-12-25 08:22:41 | 45.943200 | 24.966800 | 608561.0 | 14912.0 | 523829.0 | 69820.0 | 3163.380079 | NaN | NaN | 2.450371 | 642 | ROU |
| 141 | Russia | 2020-12-25 08:22:41 | 61.524000 | 105.318800 | 2934695.0 | 52434.0 | 2347700.0 | 534561.0 | 2010.967800 | NaN | NaN | 1.786693 | 643 | RUS |
| 142 | Rwanda | 2020-12-25 08:22:41 | -1.940300 | 29.873900 | 7670.0 | 69.0 | 6203.0 | 1398.0 | 59.217698 | NaN | NaN | 0.899609 | 646 | RWA |
| 143 | Saint Kitts and Nevis | 2020-12-25 08:22:41 | 17.357822 | -62.782998 | 30.0 | 0.0 | 26.0 | 4.0 | 56.399459 | NaN | NaN | 0.000000 | 659 | KNA |
| 144 | Saint Lucia | 2020-12-25 08:22:41 | 13.909400 | -60.978900 | 305.0 | 5.0 | 267.0 | 33.0 | 166.095769 | NaN | NaN | 1.639344 | 662 | LCA |
| 145 | Saint Vincent and the Grenadines | 2020-12-25 08:22:41 | 12.984300 | -61.287200 | 108.0 | 0.0 | 85.0 | 23.0 | 97.343777 | NaN | NaN | 0.000000 | 670 | VCT |
| 146 | Samoa | 2020-12-25 08:22:41 | -13.759000 | -172.104600 | 2.0 | 0.0 | 2.0 | 0.0 | 1.019732 | NaN | NaN | 0.000000 | 882 | WSM |
| 147 | San Marino | 2020-12-25 08:22:41 | 43.942400 | 12.457800 | 2231.0 | 56.0 | 1863.0 | 312.0 | 6573.752136 | NaN | NaN | 2.510085 | 674 | SMR |
| 148 | Sao Tome and Principe | 2020-12-25 08:22:41 | 0.186400 | 6.613100 | 1012.0 | 17.0 | 960.0 | 35.0 | 461.760988 | NaN | NaN | 1.679842 | 678 | STP |
| 149 | Saudi Arabia | 2020-12-25 08:22:41 | 23.885942 | 45.079162 | 361725.0 | 6159.0 | 352608.0 | 2958.0 | 1039.025627 | NaN | NaN | 1.702675 | 682 | SAU |
| 150 | Senegal | 2020-12-25 08:22:41 | 14.497400 | -14.452400 | 18200.0 | 381.0 | 16742.0 | 1077.0 | 108.696107 | NaN | NaN | 2.093407 | 686 | SEN |
| 151 | Serbia | 2020-12-25 08:22:41 | 44.016500 | 21.005900 | 316344.0 | 2882.0 | NaN | 313462.0 | 3620.586057 | NaN | NaN | 0.911034 | 688 | SRB |
| 152 | Seychelles | 2020-12-25 08:22:41 | -4.679600 | 55.492000 | 205.0 | 0.0 | 184.0 | 21.0 | 208.460443 | NaN | NaN | 0.000000 | 690 | SYC |
| 153 | Sierra Leone | 2020-12-25 08:22:41 | 8.460555 | -11.779889 | 2531.0 | 76.0 | 1866.0 | 589.0 | 31.728780 | NaN | NaN | 3.002766 | 694 | SLE |
| 154 | Singapore | 2020-12-25 08:22:41 | 1.283300 | 103.833300 | 58509.0 | 29.0 | 58332.0 | 148.0 | 1000.095208 | NaN | NaN | 0.049565 | 702 | SGP |
| 155 | Slovakia | 2020-12-25 08:22:41 | 48.669000 | 19.699000 | 161562.0 | 1732.0 | 114267.0 | 45563.0 | 2959.204475 | NaN | NaN | 1.072034 | 703 | SVK |
| 156 | Slovenia | 2020-12-25 08:22:41 | 46.151200 | 14.995500 | 112021.0 | 2479.0 | 91952.0 | 17590.0 | 5388.391732 | NaN | NaN | 2.212978 | 705 | SVN |
| 157 | Solomon Islands | 2020-12-25 08:22:41 | -9.645700 | 160.156200 | 17.0 | 0.0 | 5.0 | 12.0 | 2.603935 | NaN | NaN | 0.000000 | 90 | SLB |
| 158 | Somalia | 2020-12-25 08:22:41 | 5.152149 | 46.199616 | 4690.0 | 127.0 | 3605.0 | 958.0 | 29.509440 | NaN | NaN | 2.707889 | 706 | SOM |
| 159 | South Africa | 2020-12-25 08:22:41 | -30.559500 | 22.937500 | 968563.0 | 25983.0 | 822978.0 | 119602.0 | 1633.087832 | NaN | NaN | 2.682634 | 710 | ZAF |
| 160 | South Sudan | 2020-12-25 08:22:41 | 6.877000 | 31.307000 | 3455.0 | 62.0 | 3118.0 | 275.0 | 30.865496 | NaN | NaN | 1.794501 | 728 | SSD |
| 161 | Spain | 2020-12-25 08:22:41 | 40.463667 | -3.749220 | 1854951.0 | 49824.0 | 150376.0 | 1654751.0 | 3967.403720 | NaN | NaN | 2.686001 | 724 | ESP |
| 162 | Sri Lanka | 2020-12-25 08:22:41 | 7.873054 | 80.771797 | 39231.0 | 185.0 | 30568.0 | 8478.0 | 183.208994 | NaN | NaN | 0.471566 | 144 | LKA |
| 163 | Sudan | 2020-12-25 08:22:41 | 12.862800 | 30.217600 | 23316.0 | 1468.0 | 13524.0 | 8324.0 | 53.173064 | NaN | NaN | 6.296106 | 729 | SDN |
| 164 | Suriname | 2020-12-25 08:22:41 | 3.919300 | -56.027800 | 5810.0 | 118.0 | 5388.0 | 304.0 | 990.396056 | NaN | NaN | 2.030981 | 740 | SUR |
| 165 | Sweden | 2020-12-25 08:22:41 | 60.128200 | 18.643500 | 396048.0 | 8279.0 | NaN | 387769.0 | 3921.550766 | NaN | NaN | 2.090403 | 752 | SWE |
| 166 | Switzerland | 2020-12-25 08:22:41 | 46.818200 | 8.227500 | 428197.0 | 7098.0 | 311500.0 | 109599.0 | 4947.612939 | NaN | NaN | 1.657648 | 756 | CHE |
| 167 | Syria | 2020-12-25 08:22:41 | 34.802075 | 38.996815 | 10701.0 | 652.0 | 4997.0 | 5052.0 | 61.146276 | NaN | NaN | 6.092889 | 760 | SYR |
| 168 | Taiwan* | 2020-12-25 08:22:41 | 23.700000 | 121.000000 | 776.0 | 7.0 | 635.0 | 134.0 | 3.258208 | NaN | NaN | 0.902062 | 158 | TWN |
| 169 | Tajikistan | 2020-12-25 08:22:41 | 38.861000 | 71.276100 | 13106.0 | 89.0 | 12578.0 | 439.0 | 137.413419 | NaN | NaN | 0.679078 | 762 | TJK |
| 170 | Tanzania | 2020-12-25 08:22:41 | -6.369028 | 34.888822 | 509.0 | 21.0 | 183.0 | 305.0 | 0.852108 | NaN | NaN | 4.125737 | 834 | TZA |
| 171 | Thailand | 2020-12-25 08:22:41 | 15.870032 | 100.992541 | 5910.0 | 60.0 | 4130.0 | 1720.0 | 8.467051 | NaN | NaN | 1.015228 | 764 | THA |
| 172 | Timor-Leste | 2020-12-25 08:22:41 | -8.874217 | 125.727539 | 41.0 | 0.0 | 31.0 | 10.0 | 3.109731 | NaN | NaN | 0.000000 | 626 | TLS |
| 173 | Togo | 2020-12-25 08:22:41 | 8.619500 | 0.824800 | 3520.0 | 68.0 | 3186.0 | 266.0 | 42.518563 | NaN | NaN | 1.931818 | 768 | TGO |
| 174 | Trinidad and Tobago | 2020-12-25 08:22:41 | 10.691800 | -61.222500 | 7089.0 | 125.0 | 6503.0 | 461.0 | 506.541307 | NaN | NaN | 1.763295 | 780 | TTO |
| 175 | Tunisia | 2020-12-25 08:22:41 | 33.886917 | 9.537499 | 126752.0 | 4324.0 | 97776.0 | 24652.0 | 1072.477340 | NaN | NaN | 3.411386 | 788 | TUN |
| 176 | Turkey | 2020-12-25 08:22:41 | 38.963700 | 35.243300 | 2100712.0 | 19115.0 | 1935292.0 | 146305.0 | 2490.793501 | NaN | NaN | 0.909930 | 792 | TUR |
| 177 | US | 2020-12-25 08:22:41 | 40.000000 | -100.000000 | 18654396.0 | 329097.0 | NaN | 18325168.0 | 5662.004570 | NaN | NaN | 1.764179 | 840 | USA |
| 178 | Uganda | 2020-12-25 08:22:41 | 1.373333 | 32.290275 | 32914.0 | 245.0 | 10821.0 | 21848.0 | 71.957325 | NaN | NaN | 0.744364 | 800 | UGA |
| 179 | Ukraine | 2020-12-25 08:22:41 | 48.379400 | 31.165600 | 1041160.0 | 18243.0 | 669929.0 | 352988.0 | 2380.678048 | NaN | NaN | 1.752180 | 804 | UKR |
| 180 | United Arab Emirates | 2020-12-25 08:22:41 | 23.424076 | 53.847818 | 198435.0 | 647.0 | 174479.0 | 23309.0 | 2006.339481 | NaN | NaN | 0.326051 | 784 | ARE |
| 181 | United Kingdom | 2020-12-25 08:22:41 | 55.000000 | -3.000000 | 2195144.0 | 69732.0 | 4821.0 | 2120591.0 | 3233.573742 | NaN | NaN | 3.176648 | 826 | GBR |
| 182 | Uruguay | 2020-12-25 08:22:41 | -32.522800 | -55.765800 | 15457.0 | 135.0 | 10040.0 | 5282.0 | 444.968761 | NaN | NaN | 0.873391 | 858 | URY |
| 183 | Uzbekistan | 2020-12-25 08:22:41 | 41.377491 | 64.585262 | 76568.0 | 612.0 | 73911.0 | 2045.0 | 228.771534 | NaN | NaN | 0.799290 | 860 | UZB |
| 184 | Vanuatu | 2020-12-25 08:22:41 | -15.376700 | 166.959200 | 1.0 | 0.0 | 1.0 | 0.0 | 0.341670 | NaN | NaN | 0.000000 | 548 | VUT |
| 185 | Venezuela | 2020-12-25 08:22:41 | 6.423800 | -66.589700 | 111245.0 | 1006.0 | 105479.0 | 4760.0 | 391.212628 | NaN | NaN | 0.904310 | 862 | VEN |
| 186 | Vietnam | 2020-12-25 08:22:41 | 14.058324 | 108.277199 | 1432.0 | 35.0 | 1281.0 | 116.0 | 1.471154 | NaN | NaN | 2.444134 | 704 | VNM |
| 187 | West Bank and Gaza | 2020-12-25 08:22:41 | 31.952200 | 35.233200 | 129080.0 | 1243.0 | 105233.0 | 22604.0 | 2530.277868 | NaN | NaN | 0.962969 | 275 | PSE |
| 188 | Yemen | 2020-12-25 08:22:41 | 15.552727 | 48.516388 | 2092.0 | 606.0 | 1384.0 | 102.0 | 7.014022 | NaN | NaN | 28.967495 | 887 | YEM |
| 189 | Zambia | 2020-12-25 08:22:41 | -13.133897 | 27.849332 | 19234.0 | 381.0 | 18036.0 | 817.0 | 104.623836 | NaN | NaN | 1.980867 | 894 | ZMB |
| 190 | Zimbabwe | 2020-12-25 08:22:41 | -19.015438 | 29.154857 | 12786.0 | 339.0 | 10314.0 | 2133.0 | 86.026124 | NaN | NaN | 2.651337 | 716 | ZWE |
# data cleaning
# renaming the df column names to lowercase
country_df.columns = map(str.lower, country_df.columns)
confirmed_df.columns = map(str.lower, confirmed_df.columns)
death_df.columns = map(str.lower, death_df.columns)
recovered_df.columns = map(str.lower, recovered_df.columns)
# changing province/state to state and country/region to country
confirmed_df = confirmed_df.rename(columns={'province/state': 'state', 'country/region': 'country'})
recovered_df = confirmed_df.rename(columns={'province/state': 'state', 'country/region': 'country'})
death_df = death_df.rename(columns={'province/state': 'state', 'country/region': 'country'})
country_df = country_df.rename(columns={'country_region': 'country'})
# country_df.head()
# total number of confirmed, death and recovered cases
confirmed_total = int(country_df['confirmed'].sum())
deaths_total = int(country_df['deaths'].sum())
recovered_total = int(country_df['recovered'].sum())
active_total = int(country_df['active'].sum())
# displaying the total stats
display(HTML("<div style = 'background-color: #FFFFFF; padding: 30px '>" +
"<span style='color: #1F487E; font-size:30px;'> Confirmed: " + str(confirmed_total) +"</span>" +
"<span style='color: #FF5964; font-size:30px;margin-left:20px;'> Deaths: " + str(deaths_total) + "</span>"+
"<span style='color: #1F487E; font-size:30px; margin-left:20px;'> Recovered: " + str(recovered_total) + "</span>"+
"</div>")
)
# sorting the values by confirmed descednding order
# country_df.sort_values('confirmed', ascending= False).head(10).style.background_gradient(cmap='copper')
fig = go.FigureWidget( layout=go.Layout() )
def highlight_col(x):
r = 'background-color: #1D3461'
y = 'background-color: #FF5964'
g = 'background-color: #1F487E'
df1 = pd.DataFrame('', index=x.index, columns=x.columns)
df1.iloc[:, 4] = y
df1.iloc[:, 5] = r
df1.iloc[:, 6] = g
return df1
def show_latest_cases(n):
n = int(n)
return country_df.sort_values('confirmed', ascending= False).head(n).style.apply(highlight_col, axis=None)
interact(show_latest_cases, n='10')
ipywLayout = widgets.Layout(border='solid 2px green')
ipywLayout.display='none' # uncomment this, run cell again - then the graph/figure disappears
widgets.VBox([fig], layout=ipywLayout)
| country | last_update | lat | long_ | confirmed | deaths | recovered | active | incident_rate | people_tested | people_hospitalized | mortality_rate | uid | iso3 | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 177 | US | 2020-12-25 08:22:41 | 40.000000 | -100.000000 | 18654396.000000 | 329097.000000 | nan | 18325168.000000 | 5662.004570 | nan | nan | 1.764179 | 840 | USA |
| 79 | India | 2020-12-25 08:22:41 | 20.593684 | 78.962880 | 10146845.000000 | 147092.000000 | 9717834.000000 | 281919.000000 | 735.276287 | nan | nan | 1.449633 | 356 | IND |
| 23 | Brazil | 2020-12-25 08:22:41 | -14.235000 | -51.925300 | 7423945.000000 | 189982.000000 | 6512717.000000 | 721246.000000 | 3492.644732 | nan | nan | 2.559044 | 76 | BRA |
| 141 | Russia | 2020-12-25 08:22:41 | 61.524000 | 105.318800 | 2934695.000000 | 52434.000000 | 2347700.000000 | 534561.000000 | 2010.967800 | nan | nan | 1.786693 | 643 | RUS |
| 62 | France | 2020-12-25 08:22:41 | 46.227600 | 2.213700 | 2584333.000000 | 62389.000000 | 194559.000000 | 2327385.000000 | 3959.236941 | nan | nan | 2.414124 | 250 | FRA |
| 181 | United Kingdom | 2020-12-25 08:22:41 | 55.000000 | -3.000000 | 2195144.000000 | 69732.000000 | 4821.000000 | 2120591.000000 | 3233.573742 | nan | nan | 3.176648 | 826 | GBR |
| 176 | Turkey | 2020-12-25 08:22:41 | 38.963700 | 35.243300 | 2100712.000000 | 19115.000000 | 1935292.000000 | 146305.000000 | 2490.793501 | nan | nan | 0.909930 | 792 | TUR |
| 85 | Italy | 2020-12-25 08:22:41 | 41.871900 | 12.567400 | 2009317.000000 | 70900.000000 | 1344785.000000 | 593632.000000 | 3323.281923 | nan | nan | 3.528562 | 380 | ITA |
| 161 | Spain | 2020-12-25 08:22:41 | 40.463667 | -3.749220 | 1854951.000000 | 49824.000000 | 150376.000000 | 1654751.000000 | 3967.403720 | nan | nan | 2.686001 | 724 | ESP |
| 66 | Germany | 2020-12-25 08:22:41 | 51.165691 | 10.451526 | 1630596.000000 | 29333.000000 | 1220277.000000 | 380986.000000 | 1946.191481 | nan | nan | 1.798913 | 276 | DEU |
sorted_country_df = country_df.sort_values('confirmed', ascending= False)
# # plotting the 20 worst hit countries
def bubble_chart(n):
fig = px.scatter(sorted_country_df.head(n), x="country", y="confirmed", size="confirmed", color="country",
hover_name="country", size_max=60)
fig.update_layout(
title=str(n) +" Worst hit countries",
xaxis_title="Countries",
yaxis_title="Confirmed Cases",
width = 700
)
fig.show();
interact(bubble_chart, n=10)
ipywLayout = widgets.Layout(border='solid 2px green')
ipywLayout.display='none'
widgets.VBox([fig], layout=ipywLayout)
def plot_cases_of_a_country(country):
labels = ['confirmed', 'deaths']
colors = ['blue', 'red']
mode_size = [6, 8]
line_size = [4, 5]
df_list = [confirmed_df, death_df]
fig = go.Figure();
for i, df in enumerate(df_list):
if country == 'World' or country == 'world':
x_data = np.array(list(df.iloc[:, 20:].columns))
y_data = np.sum(np.asarray(df.iloc[:,4:]),axis = 0)
else:
x_data = np.array(list(df.iloc[:, 20:].columns))
y_data = np.sum(np.asarray(df[df['country'] == country].iloc[:,20:]),axis = 0)
fig.add_trace(go.Scatter(x=x_data, y=y_data, mode='lines+markers',
name=labels[i],
line=dict(color=colors[i], width=line_size[i]),
connectgaps=True,
text = "Total " + str(labels[i]) +": "+ str(y_data[-1])
));
fig.update_layout(
title="COVID 19 cases of " + country,
xaxis_title='Date',
yaxis_title='No. of Confirmed Cases',
margin=dict(l=20, r=20, t=40, b=20),
paper_bgcolor="lightgrey",
width = 800,
);
fig.update_yaxes(type="linear")
fig.show();
interact(plot_cases_of_a_country, country='World')
ipywLayout = widgets.Layout(border='solid 2px green')
ipywLayout.display='none' # uncomment this, run cell again - then the graph/figure disappears
widgets.VBox([fig], layout=ipywLayout)
px.bar(
sorted_country_df.head(10),
x = "country",
y = "confirmed",
title= "Top 10 worst affected countries", # the axis names
color_discrete_sequence=["#1D3461"],
height=500,
width=800
)
px.bar(
sorted_country_df.head(10),
x = "country",
y = "deaths",
title= "Top 10 worst affected countries", # the axis names
color_discrete_sequence=["#FF5964"],
height=500,
width=800
)
px.bar(
sorted_country_df.head(10),
x = "country",
y = "recovered",
title= "Top 10 worst affected countries", # the axis names
color_discrete_sequence=["#1F487E"],
height=500,
width=800
)
import math
world_map = folium.Map(location=[11,0], tiles="cartodbpositron", zoom_start=2, max_zoom = 6, min_zoom = 2)
for i in range(0,len(confirmed_df)):
if (-360<confirmed_df.iloc[i]['lat']<360 and -360<confirmed_df.iloc[i]['long']<360 ):
folium.Circle(
location=[confirmed_df.iloc[i]['lat'], confirmed_df.iloc[i]['long']],
fill=True,
radius=(int((np.log(confirmed_df.iloc[i,-1]+1.00001)))+0.2)*50000,
color='#FF5964',
fill_color='#FF5964',
tooltip = "<div style='margin: 0; background-color: black; color: white;'>"+
"<h4 style='text-align:center;font-weight: bold'>"+confirmed_df.iloc[i]['country'] + "</h4>"
"<hr style='margin:10px;color: white;'>"+
"<ul style='color: white;;list-style-type:circle;align-item:left;padding-left:20px;padding-right:20px'>"+
"<li>Confirmed: "+str(confirmed_df.iloc[i,-1])+"</li>"+
"<li>Deaths: "+str(death_df.iloc[i,-1])+"</li>"+
"<li>Death Rate: "+ str(np.round(death_df.iloc[i,-1]/(confirmed_df.iloc[i,-1]+1.00001)*100,2))+ "</li>"+
"</ul></div>",
).add_to(world_map)
world_map